Pasting pictures of cells and charts

Excel 2003
One of Excel's best-kept secrets is its ability to copy and paste pictures of cells. You can copy a cell or range and then paste a picture of the cell or range on any worksheet or chart.

When pasting to a worksheet, the picture can be static or linked. With a linked picture, the link is to the cells. In other words, if you change the contents of a cell that's in a picture, the picture changes.

To create a picture of a cell or range, select a range and choose Edit -> Copy. Then press Shift and click the Edit menu. Choose Paste Picture to create a static picture, or choose Paste Picture Link to paste a linked picture of the selection. You can paste a picture of a range into a chart, but Excel does not allow you to paste a linked picture of a range into a chart.

Another useful technique is to copy an embedded chart and paste it as a picture. To do so, press Ctrl and click the chart. Then press the Shift key and choose Edit -> Copy Picture (this command is available only when you press Shift). Excel displays it's Copy Picture dialog box. Accept the default settings and click OK. Then, select a cell and choose Edit -> Paste. The result is a picture of the chart. It's not a "live" chart, so it will no longer be updated if the original chart's source data changes.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.