At times, you might need to include screenshots in your Excel spreadsheets. This could be snapshots of specific data ranges, charts within Excel, or screenshots from other software applications that you wish to insert into your spreadsheets.

Excel includes tools and options that enable you to capture screenshots the easy way. This is how you can capture screenshots of your spreadsheets and external applications with the Excel desktop app.

Excel’s File tab

How to Capture Spreadsheet Screenshots With Excel’s Camera Tool

Excel has a built-in camera tool with which you may capture a screenshot of any selected area within your spreadsheet. That utility enables you to take snapshots of data ranges, charts, and tables from one sheet and then add the screen clippings to different areas of your spreadsheet.

The camera tool isn’t enabled by default in Excel. It’s an optional utility you can add bycustomizing the Quick Access Toolbar in Excel. You can enable Excel’s camera tool and take screenshots with it as follows:

The Quick Access Toolbar

The inserted screenshot is a picture you can rotate and resize with the mouse. You can also select various editing options on thePicture Formattab.

For example, move the cursor overPicture Effectsto select an effect option within theShadow,Reflection,Glow,Soft Edges, andBevelsub-menus. Or select an option within thePicture Stylesbox to apply a style.

A chart screenshot selection

How to Capture Spreadsheet Screenshots With Excel’s Copy as Picture Option

you’re able to capture screenshots of selected spreadsheet areas with Excel’sCopy as Pictureoption. That option enables you to copy selected sheet areas as bitmap images.

Then, you may paste the copied bitmap picture into another part of your spreadsheet. This is how you can capture spreadsheet screenshots with theCopy as Pictureoption:

The Camera option

This pasting method will insert a picture of the captured spreadsheet area much the same as utilizing the camera tool. you’re able to select all the same options for the screenshot from Excel’sPicture Formattab. Drag and drop the picture into a suitable position on your sheet and resize it with the cursor.

How to Capture External Screenshots With Excel’s Screenshot Tool

If you need to capture a snapshot of software outside of Excel, you may do so by utilizing the Screenshot tool. The Screenshot tool enables you to take a shot from the desktop area or a software window. You can capture external screenshots with the utility like this:

You can also take full-screen window screenshots instead of clippings. To do so, click one of the available window thumbnails within Excel’s screenshot tool. This action will capture a full-screen snapshot of the selected window.

A graph screenshot captured with Excel’s Camera tool

Easily Capture All Necessary Spreadsheet Screenshots With Excel

Although you can feasibly capture screenshots for your spreadsheets with third-party screen-capturing tools, it’s quicker and more convenient to take the snapshots you need within Excel.

Capturing snapshots of your spreadsheets or external software packages is straightforward with Excel’s Camera, Screenshot, and Copy as Picture options. Those screenshot options are invaluable for capturing on-screen info from your Excel spreadsheets or other apps.