Copy A Group Of Cells In Excel 2007 To The Clipboard As An Image

The command in Excel 2007 to do this is oddly located on the Paste menu in the Ribbon. From the Home tab, click on the drop-down menu under the Paste button, and select As Picture \ Copy as Picture.

Now you will get a dialog asking you how you want to copy the picture. If you want to paste the picture into any application, you’ll need to select “As shown on screen”, and then “Bitmap”.

Now your cell data should be on the clipboard, ready to paste into any application that allows you to paste in a bitmap. Here’s an example of a bitmap I pasted into the editor I use for writing articles here:

Very useful!