Datasheet

Taking Pictures of Ranges

Excel 2007 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.

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 ➪

As Picture ➪ Paste As Picture. The result is a graphical image of the original range. 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 18-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.

Figure 18-1: A picture of a range, after applying some picture formatting.

Tip 18: Taking Pictures of Ranges

Part I

04_137666 ch01.qxp 5/22/07 7:31 PM Page 49