Copy a Group of Cells in Excel 2007 to the Clipboard as an Image If you need to copy a group of cells from Excel 2007 to the clipboard, there are a few ways you can do it. One way is to use the Copy command on the Home tab. Another way is to use the Paste command on the Home tab, and then select the cells you want to copy. The third way is to use the Clipboard button on the Home tab. This button lets you copy any selection, including groups of cells. ..


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!