• Excel Book Excerpt

Excel Paste a Live Picture of a Cell

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Paste a Live Picture of a Cell

Problem: I have a massively large spreadsheet. I’m working on calculations in the top of the spreadsheet but need to monitor a result in W842. It is a pain to travel back and forth to monitor that cell.

Strategy: You can take a picture of the cell and paste it where you can keep an eye on it. Follow these steps:

1. Select cells W841:W842. Press Ctrl+C to copy.

2. Return to the top of the worksheet. Select an area that has a few blank cells. Select Home, Paste dropdown, As Picture, Paste Picture Link.

A live picture of the cell will be pasted.

LE10001322.jpg 

Figure 1267 G7:G8 is a live picture of cells W841:W842.

As you make changes and the calculations cause the result to change, the picture will update.

Additional Details: The picture can be of multiple cells. Also, it is possible to move the picture by dragging it to a new location. You can even paste several pictures, each of a different few summary cells in order to have a dashboard showing key cells from throughout the workbook.

See Also: “Monitor Distant Cells" on page 254.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel:

privacy policy