Microsoft Office Tutorials and References
In Depth Information
Creating screenshots or pictures of your worksheets
The image is dynamically linked to the cells originally selected, not to their contents. As a
result, the pasted image changes dynamically whenever the contents of the original cells
change. This way, you can create “activity monitors” on a summary sheet, showing you the
contents of remote cells in real time.
Any graphic objects that happen to be within or overlapping the selected range also
are displayed in the linked picture.
When you select the linked picture, the formula bar displays a reference formula, as shown
in Figure 10-54. After you create the picture, you can edit the formula and the picture
changes accordingly. You can even change the references and link to a different worksheet
or workbook. The link between the source and destination documents has another
distinctive and useful characteristic. Suppose you close the Northwind Sales worksheet shown on
the left in Figure 10-54. If you then double-click the embedded image in Book2, Northwind
Sales opens automatically, with the pictured range selected. You can use it in this way to
quickly create “buttons” for opening supporting workbooks.
After you paste the linked picture, you can change its size and proportions by dragging its
selection handles and treating it just like any other graphic object. Changes in shape, size,
and formatting do not affect the dynamic updating of the data displayed in the picture.
The Picture button on the Home tab’s Paste menu does essentially the same thing as the
Linked Picture button, minus the linking formula, so you can’t change it after you paste,
and there is no connection to the source if you paste it into a different document.
For more information about linking formulas, see “Formula fundamentals” in Chapter 12.
Creating linked images of cells using the Camera button
The Camera button offers a slightly faster way of doing what the Linked Picture button
does. With the Camera button, the cells are linked, pasted as shown on screen (rather than
as shown when printed), and the image changes dynamically if the contents of the original
When using the Linked Picture button, you select the destination before you click; when
using the Camera button, you select the destination after you click. If you select the same
range (F3:F16) as we did in the worksheet shown in Figure 10-54, click the Camera button,
and the pointer changes from a plus sign to crosshairs. Then just click where you want the
upper-left corner of the picture to appear, and Excel embeds the picture just as shown on