See all Microsoft Excel tips
Strategy: Take a picture of the cell and paste it where you can keep and eye on it.
1) As shown in Fig. 1243, select the cell W842. Hit Ctrl+C to copy.
2) Return to the top of the worksheet. Select an area with a few blank cells. Hold down the Shift key while you access the Edit menu. A Paste Picture Link choice is magically available, as shown in Fig. 1244.
3) Choose Paste Picture Link. A live picture of the cell will be pasted, as shown in Fig. 1245.
As you make changes and the calculations cause the result to change, the picture will update, as shown in Fig. 1246.
Additional Information: The picture can be of multiple cells. Also, it is possible to move the picture by dragging it to a new location.
Summary: You can paste a live picture of distant cells. Copy the cells. Then, while holding down the Shift key, select Edit – Paste Picture Link. Paste the picture in your spreadsheet where you need to monitor its results.
Commands Discussed: Shift+Edit – Paste Picture Link
See all Microsoft Excel tips
