Subscribe to How-To Geek

Copy a Group of Cells in Excel 2007 to the Clipboard as an Image

If you want to share a small part of your Excel worksheet but don’t want to send an Excel file, you can copy part of the worksheet to the clipboard as a picture instead, which can be pasted into any application that supports images, such as your favorite image editor.

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.

4

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”.

image

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:

image

Very useful!

| More
This article was originally written on 07/4/07 Tagged with: Microsoft Excel, Microsoft Office

Daily Email Updates

You can get our how-to articles in your inbox each day for free. Just enter your name and email below:


Name:
Email:

Comments (3)

  1. Andrew Griffiths

    Your post alerted me to this very useful feature; thank you. However, I still use Excel 2003 a lot as many of my colleagues have not upgraded. After some research I found that the same feature exists in 2003. Amazingly, it’s completely hidden! Hold down the shift key and click on edit to reveal.

  2. mysticgeek

    Andrew,

    Thank you for the additional information about 2003!

  3. Angel

    I had been looking for this ever since I upgraded. I thought Microsft had done away with this nifty trick!


Leave a Comment




Leave your friendly comment here.

If you have a computer help question, click here to leave it on the forums instead.

Note: Your comment may not show up immediately on the site.

Our Friends
Getting Started


About How-To Geek
What Is That Process?
svchost.exe
jusched.exe
dwm.exe
ctfmon.exe
wmpnetwk.exe
mDNSResponder.exe
wmpnscfg.exe
rundll32.exe
wfcrun32.exe
Ipoint.exe
Itype.exe
Wfica32.exe
Mobsync.exe
conhost.exe
Dpupdchk.exe Adobe_Updater.exe

Copyright © 2006-2009 HowToGeek.com. All Rights Reserved.