Microsoft Office Tutorials and References
In Depth Information
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 dead
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
(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 contextual menu — which means that you can apply some additional
formatting to the picture.
Other Paste Options
Figure 20-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
Picture Styles gallery. It’s a static picture, so
changes made within the range B2:E9 are not shown in the picture.
Figure 20-1: A picture of a range, after applying some picture formatting.
Search JabSto ::

Custom Search