Microsoft Office Tutorials and References
In Depth Information
Tip 98: Taking Pictures of Ranges
Taking Pictures of Ranges
Excel makes it easy to convert a range of cells into a picture. The picture can either be a static image
(it doesn’t change if the original range changes) or a live picture (which reflects changes in the
original range). The range can even contain objects, such as charts or shapes.
Creating a static image of a range
To create a snapshot of a range, start by selecting a range of cells and then press Ctrl+C to copy the
range to the Clipboard. Then choose Home➜Clipboard➜Paste➜Other Paste Options➜Picture (U).
The result is a graphic image of the original range, pasted on top of the original range. Just click and
drag to move the picture to another location. When you select this image, Excel displays its Picture
Tools context menu — which means that you can apply some additional formatting to the picture.
Figure 98-1 shows a range of cells (B2:E9), along with a picture of the range after I applied one of the
built-in styles from the Picture Tools➜Format➜Picture Styles gallery. It’s a static picture, so changes
made within the range B2:E9 aren’t shown in the picture.
If you want to include a graphic that shows information from another (non-Excel)
window, choose Insert Illustrations Screenshot. You can capture an entire window or ➜
just a portion of a window (by choosing Screen Clipping). The copied information is
pasted as a picture in the active worksheet.
Figure 98-1: A picture of a range, after applying some picture formatting.