Datasheet

Creating a Live Image of a Range
To create an image that’s linked to the original range of cells, select the cells and press
Ctrl+C to copy the range to the Clipboard. Then choose Home Clipboard Paste
As Picture Paste Picture Link. Excel pastes a picture of the original range, and the pic-
ture is linked — if you make changes to the original, those changes are shown in the
linked picture.
Notice that when you select the linked picture, the formula bar displays the address of the
original range. You can edit this range reference to change the cells that are displayed in
the picture. To “de-link” the picture, just delete the formula on the formula bar.
You can also cut and paste this picture to a different worksheet, if you like. That makes it
easy to refer to information on a different sheet. Unfortunately, Excel doesn’t allow much
formatting of this picture. You can change its size by dragging a corner, but none of the
standard picture formatting commands is available.
Figure 18-2 shows a linked picture of a range placed on top of a shape, which has lots of
interesting formatting capabilities. Placing a linked picture on top of a shape is a good way
to make a particular range stand out.
Figure 18-2: A linked picture of a range, placed on top of a shape.
Tip 18: Taking Pictures of Ranges
50
04_137666 ch01.qxp 5/22/07 7:31 PM Page 50