|  

» 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.
Screenshot // Using a Picture to Watch Cell Values in Other Sheets
Using a Picture to Watch Cell Values in Other Sheets
Rate This Tip
12 34 5
Rating: 3.33     Views: 32526
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments