Hello all and welcome back to the Excel Tip of the Week! This week we have a Basic User post in which we're going to explain the various ways to create an image of an Excel spreadsheet, or just part of it.
Whether you need a capture for a presentation, or to create documentation, or to make an illustration for a popular weekly Excel tip series, screenshotting is a natural part of the Excel workflow. But you might not know that there are some handy options available to make your life easier!
Windows supports a simple print screen function, which most keyboards and laptops dedicate a button to. In case you aren't familiar, this button will put a copy of what's on your screen into your clipboard. From there, you can paste to get a copy of the image wherever you're working.
Pros: Simple, quick
Cons: Can only capture the full screen at once
This option, found on the Insert Ribbon, can quickly create and post an image of any other window that you have open, and instantly paste it into the current workbook:
You can also use the 'Screen Clipping' tool at the bottom to instead draw a box and capture just part of one of the other windows.
Pros: Specific capture, quick
Cons: Can't capture from within the active workbook
Paste as picture
If you just want to capture the contents of some cells, you can copy those cells and then paste as an image:
Note that this option is not on the standard Paste Special menu!
Pasting will create a static image of your cells. It's transparent, which can make seeing it against an Excel backdrop a bit difficult, but it's an exact crop of what you copied so is useful for getting an accurate snapshot into another program.
Pros: Cell-exact capture
Cons: Harder to access, can be hard to read
Paste as linked picture
On the same menu as Paste as Image (also on the Home Ribbon), there's an option to paste as a linked image just to the right:
This has a similar appearance to the before - but with one key difference. This linked picture is linked to the live cells - so if you make a change to the cells, the picture is changed also. You can see that when you select the picture, a sort of formula is shown in the formula bar - and indeed, you can change this formula to edit what is shown in the picture. Unfortunately, the link lasts only as long as the picture remains in Excel - copy it into another program, and it will become just a static image.
Pros: Live updating, easy editability
Cons: Harder to access, doesn't work outside of Excel
And that's the guide!
Previous post - Revisiting AutoSumTOTW index Next post - VBA case study: Making a hyperlinked table of contents
This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Filtered. There is also an online forum where you can ask questions and share ideas with other community members.
Thanks David - 2 comments -Pressing 'ALT' and 'Print Screen' simultaneously will copy just the current live window and not the whole screenUse the Windows Snipping Tool - it is fantastically useful and flexible - in Win10 its in Windows Accessories or search for 'snip'