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.

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.