To copy and paste data as a picture (image) follow these steps:

1. Select the range you want to copy.

2. While holding down the SHIFT key, Click on the Edit menu.

3. Click Copy Picture.

4. Select a cell in the range where you want to paste the picture.

5. Click Paste Picture in the Edit menu ( while holding down the SHIFT key).

*Applies to: Excel 2003*

How can this feature work in Excel 2007. specifically, I want the linking back to the original range area in case data changes, i want the image updated. The shift key doesn’t seem to work in Excel 2007 for this copy picture feature.

Because the answer requires some details, I have created a new post for this purpose. Here is the link:

http://www.exceldigest.com/myblog/2009/10/30/paste-data-as-a-picture-image-in-excel-2007/

Ok, so how do you do this in exell 2010?

To see how to do it in Excel 2007 check this post.

The difference in Excel 2010 is that in point 4 instead of seeing a text that say “As Picture” you will find a small icon named “Picture”.

I am working in excel 2003. When I copy data from the excel spreasheet and I want to paste it onto a blank form including formulas. In the new form I go to paste special. The only option then is to paste it as a picture. There is no option to paste as an excel worksheet