Excel camera

Excel allows you to capture portions of your worksheet as a picture that you can then use in a variety of other ways. This picture is linked to the source. Here’s how to take the snapshot.

Excel provides a nifty little tool that allows you to create a picture from a range of cells, from a chart, or from another object in your worksheet. Follow these steps:
Select the cells or other object you want a picture of. (If you select cells, they must be contiguous.)
Display the Home tab of the ribbon.
Click the down arrow under the Paste tool in the Clipboard group. Excel displays a list of options.
Click As Picture to display a submenu.
Click Copy as Picture. Excel displays the Copy Picture dialog box. (Click here to see a related figure.)
In the top part of the dialog box, specify what you want in the picture.
In the bottom part of the dialog box, specify how you want the graphic saved.
Click OK.
The result is that you now have a graphic in the Clipboard—either a metapicture or a bitmap, depending on your choice in the bottom portion of the dialog box—that you can paste anywhere. Paste it in another workbook, paste it in an e-mail, or paste it in a Word document. You can paste it just about anywhere because it is no longer an Excel object, but an actual graphic.
You should know that if you choose “As Shown On Screen” in the Copy Picture dialog box, that doesn’t mean that Excel copies the picture exactly as shown. The copied picture will always be at a 100% zoom magnification, regardless of what zoom setting you are using.

No Comments

Leave a reply

You must be logged in to post a comment.