"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

Create A Linked Picture Of A Range Of Cells

Who says you can't be in two places at the same time?

Here is a neat trick that I bet you'll find many uses for. Believe it or not, in Excel you can 'take a picture' of a range of cells and paste that picture anywhere in your workbook.

The great thing about this is that the picture is linked to that range of cells and whenever the contents of those cells change, the picture is also updated. This is useful when you are working in one part of your workbook and you want to see how changes you make affect another part of your spreadsheet. You'll probably think of a hundred other uses for it.

To create a linked picture:

  1. Select the cells whose picture you want to take;
  2. Click Edit, Copy.
  3. Select a cell where you want to place the picture;
  4. While holding down the SHIFT key click on the Edit menu and select Paste Picture Link. (The Paste Picture Link menu item is available only when you hold down the SHIFT key while clicking on the Edit menu).
The result is a linked picture that is updated whenever the source cells are changed or formatted. If the picture has an invisible background so you may find the need to add some background color to it (Format, Picture, Colors and Lines, and select a Fill color) to make it easier to read.

NOTE: If you donít want youíre picture linked, you can click Paste Picture instead to give a snapshot of the copied cells.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright © 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.