Tip Printed from ExcelTip.com

---

Using a Picture to Watch Cell Values in Other Sheets


Using keyboard shortcuts

To paste a linked picture:

1. Select the relevant cells in the sheet, and press Ctrl+C to copy.
2. Select a different cell in any sheet.
3. Hold the Shift key, and from the Edit menu, select Paste Picture Link.

Using the mouse

To use the Camera icon, add it to the regular toolbar:

1. Point with the mouse on any toolbar, right-click, and select Customize from the shortcut menu.
2. Select the Commands tab, and from the Tools category drag the Camera icon to the Standard toolbar and then close the Customize dialog box.
3. Select the relevant cells in the sheet and press the Camera icon.
4. Select any cell in the sheet (or in any other sheet) and paste the linking picture.