«

»

Mar 25

Create a Link that is a Picture

Copy a range of cells to the clipboard, then hold the Shift key and click the Edit menu. Click the Paste Picture Link. (This option is not available unless you hold the Shift key) This creates a picture that is linked to the cells you copied. You can move this picture around as you would a graphic. The picture updates automatically when you change the related cells. This is a helpful way to combine data from multiple locations on to a single sheet, particularly for printing purposes.