Microsoft Office Tutorials and References
In Depth Information
Creating a live image of a range
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➜Other Paste Options➜Linked
Picture (I). Excel pastes a picture of the original range, and the picture 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
unlink the picture, just delete the formula on the Formula bar.
As with an unlinked picture, you can use Excel’s Picture Tools context menu to modify the
appearance of the linked picture.
You can also cut and paste this picture to a different worksheet, if you like. Doing so makes it easy to
refer to information on a different sheet.
Figure 98-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 98-2: A linked picture of a range, placed on top of a shape.
Search JabSto ::

Custom Search