Excel 2010 Bible

Part III: Creating Charts and Graphics

534

One of Excel’s best-kept secrets is its ability to copy and paste “live” pictures of cells and charts. You

can copy a cell or range and then paste a picture (as an object) of the cell or range on any worksheet or

chart. If you change the contents of a cell that’s in a picture, the picture changes. The accompanying

image shows a picture of a range after applying some picture effects.

To “take a picture” of a range

1. Select the range.


2. Press Ctrl+C to copy the range.


3. Activate another cell.


4. Choose Home ➪ Clipboard ➪ Paste ➪ Linked Picture (I).

The result is a live picture of the range you selected in Step 1.

Taking Pictures of Ranges

1. Make sure that the window you want to use displays the content that you want.


2. Choose Insert ➪ Illustrations ➪ Shapes. You’ll see a gallery that contains thumbnails
   of all windows open on your computer.


3. Click the image you want. Excel inserts it into your worksheet.

When the image is selected, you can use any of the normal picture tools.