Wednesday, January 8, 2014

Copy as Picture in Excel



Copy as Picture in Excel


If you copy and paste from an Excel workbook into e.g. Word, everything suddenly looks different. The gridlines disappear, and Word might also change the width of the columns and the height of the rows. What we want to do is to take a snapshot; to copy as a picture. But how? In Excel 2007 and Excel 2010 there is an easy way to do it, which I’m going to show you here. This works with both cell selections and charts.
In Excel 2010, select the range you want to take a snapshot of and click on the little arrow next to Copy, as shown on the picture below. Choose Copy as Picture.
If you want to do this often, you might want to use the shortcut instead: Alt => H => C => P => Enter
Copy as Picture in Excel
In the dialog box, choose As shown on screen and Picture.
Copy as Picture in Excel
Paste into Word, Powerpoint, Outlook or another application, and it will look like this:
Copy as Picture in Excel
In Excel 2007 you will find this feature in the paste menu (don’t ask me why…):
Copy as Picture in Excel

No comments:

Post a Comment