Excel - How do you take a 'snapshot' of an excel page (including toolbar)

Asked By Pa on 06-Sep-07 10:04 PM
I'm doing some informal Excel training for a family member and wanted to make
up a few pages for her to refer to.  I've seen pictures online of the excel
toolbar, for example with the File dropdown menu showing.  How do I 'take a
picture' of this to put into another program (word or Adobe InDesign)?

Steve Yandl replied on 06-Sep-07 10:13 PM

The 'print scr' key captures a bitmap picture of the screen to the
clipboard.  If you hold down the 'Alt' key while pressing 'print scr' the
capture is limited to the active window.  I use CorelDraw (Photopaint) as my
graphics manipulation program, you probably use Adobe or perhaps a free
program like IrfanView.  The key is to open your graphics program, create a
new file (in my case I create a new file from the clipboard contents) and if
still needed, paste the picture in the clipboard into your new image.  Now
you can clip the image or add text notations or make other picture edits
before saving as a jpg, gif or some other format that your family member
might easily be able to open.

Dave Peterson replied on 07-Sep-07 07:33 AM
Depending on what you're copying, you may be able to use this:

Select a range
shift-edit|Copy Picture

Then go to MSWord and paste there.

This is nice for things on the worksheet (ranges, objects, charts, ...).  But
not good if you need the toolbars.

If you're going to do this a lot, you may want to look at something like Snagit
from http://www.techsmith.com (commercial product--not freeware).

Or look for a freeware/shareware program that does the same kind of thing.


Dave Peterson
Gord Dibben replied on 07-Sep-07 09:24 AM
I use the capture from FastStone and it is FREE.

Their image viewer is good also.


Gord Dibben  MS Excel MVP
Mark Lincoln replied on 07-Sep-07 11:51 AM
Gord, Capture appears to be shareware now.  According to the site,
it is free for a 30-day trial, after which it must be paid for or

Mark Lincoln
Gord Dibben replied on 08-Sep-07 10:39 AM
Thanks for the update Mark.

Haven't been to the site for a few months.

Don't know when it became Shareware and not Freeware.