Microsoft Office Tutorials and References
In Depth Information
Pasting pictures of cells
Pasting pictures of cells
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. 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.
If you’re a risk-taker, you can try this. Paste a picture of a range into a chart.
Then select the picture and enter a formula into the Formula bar. For
example, if your picture is a picture of range A1:C8 on Sheet1, enter this formula:
This will convert the picture into a linked picture. However, it may be
accompanied by some strange behavior when the chart is activated. I give no
guarantees that this technique won’t crash your system!
Figure 6-27 shows an example of a picture of a range pasted into a chart. This
technique can be a good alternative to using a data table.
Figure 6-27: The chart contains a picture of the
cells in A6:C8.
Search JabSto ::

Custom Search