Screen Shots From Excel 2010

After all the fun with SmartArt charts last week, I finally noticed the Screenshot command, that's right beside SmartArt. With the Screenshot command, you can capture an image of an entire window, or use Screen Clipping for a smaller image.


Have you used this feature? I guess Screen Clipping would be useful if you don't have any other screen capture software, but it seems rather limited.

Screen Clipping Example

As soon as you click the Screen Clipping command, the Excel window minimizes, showing the window behind it. You have a couple of seconds to find a different window that you want to capture. Or, you could restore the Excel window, and capture a piece of that.

If you change your mind, just press the Esc key, to cancel the Screen Clipping.

I grabbed this shot of the VBE window, showing a bit of code. The picture was placed on the active worksheet, and I cut it from there, and pasted it into this blog post.


Using Screen Clipping in Excel

This feature makes more sense in Word, where you might be writing documentation for your Excel files, or other software.

Can you think of a good way to use Screen Clipping in Excel?


You may also like...

5 Responses

  1. Hui... says:

    As opposed to the Free and Supplied with Windows Vista and 7, Snipping Tool, no.

  2. Gerald Strever says:

    I prefer using Snagit from It is feature-rich, works with anything on your screen and is not expensive (US$49.95). One can download a free 30-day trial. Mac version also available. BTW – I don’t get commission – I just love the program!

  3. Claire says:

    Agree with Hui–is there any advantage with using Excel’s screenshots over snipping tool?

  4. sam says:

    A Nice improvement in 2010 is a feature called background removal…on the contextual tab when you click on a picture.

  5. Esme Bodenstein says:

    How can you do a screen shot from one Excel workbook to another Excel workbook?

Leave a Reply

Your email address will not be published. Required fields are marked *