Chapter 22: Enhancing Your Work with Pictures and Drawings
535
Note
Keep in mind that the image is static. If the program from which it was taken updates its window, the image in
your worksheet will not change. n
In many cases, you don’t want the entire window — just a portion of it. The solution is to crop the
inserted screenshot by choosing Picture Tools ➪ Format ➪ Size ➪ Crop. This command adds
cropping marks to the corners of the image. Just drag the cropping marks to crop the image.Displaying a worksheet background image
If you want to use a graphics image for a worksheet’s background (similar to wallpaper on the
Windows desktop), choose Page Layout ➪ Page Setup ➪ Background and select a graphics file.
The selected graphics file is tiled on the worksheet. Unfortunately, worksheet background images
are for onscreen display only. These images do not appear when the worksheet is printed.Using the Equation Editor
New Feature
The final topic in this chapter deals with the new Equation Editor. Use this feature to insert a nicely formatted
mathematical equation as a graphic object. n
Figure 22.17 shows an example of an equation in a worksheet. Keep in mind that these equations
do not perform calculations: They are for display purposes only.If you use this feature frequently, you can save some time by adding the Excel Camera tool to your
Quick access toolbar:- Right-click the Quick Access toolbar and choose Customize Quick Access Toolbar from the
shortcut menu that appears. - On the Customization tab of the Excel Options dialog box, select Command Not in the
Ribbon from the drop-down list on the left. - Select Camera from the list and click Add.
- Click OK to close the Excel Options dialog box.
After you add the Camera tool to your Quick Access toolbar, you can select a range of cells and click
the Camera tool to take a “picture” of the range. Then click in the worksheet, and Excel places a live
picture of the selected range on the worksheet’s draw layer. If you make changes to the original ranges,
the changes are shown in the picture of the range.