It's hard to keep an eye on data in Sheet A while you're working in Sheet B. You could jump back and forth between the two sheets, but that's inefficient. An easier method is to take a picture of the data you want to watch and insert it into Sheet B. While you're working in Sheet B, you can see the data in Sheet A.
To copy the data from Sheet A as linked data do the following:
- Select the data and copy it to the Clipboard by pressing [Ctrl]+C.
- Move to the sheet where you want to paste a picture of the selected data. You don't have to worry about existing values. Excel will paste the link as a picture object, which you can move around. It won't overwrite existing data.
- Hold down the [Shift] key and choose Paste Picture Link from the Edit menu. In Excel 2007, click the Home tab and choose As Picture from the Paste drop-down list (in the Clipboard group). Then, choose Paste Picture Link.
- Choose Toolbars from the View menu and select Customize.
- Click the Commands tab.
- Select Tools in the Categories control.
- Drag and drop the Camera tool to a menu.
About Susan Harkins
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
Full Bio
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
