how to take a screenshot on excel

How to Take a Screenshot in Excel

By Laura Lewis
AD

Capturing screenshots in Microsoft Excel can be a useful way to document important data or share information with others. Excel provides several built-in methods to take screenshots within your workbook. Let's explore the most common ways to capture screenshots in Excel.

Before we dive into the methods, make sure your Excel version is up-to-date. The steps might vary slightly depending on your Excel version. Here, we'll cover the process for Excel 2016 and later, as well as Excel for Microsoft 365.

Using Keyboard Shortcuts

Keyboard shortcuts are a quick and efficient way to capture screenshots in Excel.

AD
How to Insert a Screenshot in Excel - 3 Steps - ExcelDemy
How to Insert a Screenshot in Excel - 3 Steps - ExcelDemy
How to Capture Screenshots With Excel
How to Capture Screenshots With Excel
How To Insert Screenshot In Excel
How To Insert Screenshot In Excel

For a full-page screenshot, press:

  • Print Screen (PrtScn) key on your keyboard.

For an active window screenshot, press:

How to Turn a Screenshot Into Excel Data
How to Turn a Screenshot Into Excel Data
How to Convert Screenshot Into Excel Sheet
How to Convert Screenshot Into Excel Sheet
  • Alt + Print Screen (Alt + PrtScn).

Saving and Pasting Screenshots

After taking a screenshot using the keyboard shortcuts, you can:

  • Save the screenshot as an image file by pressing Ctrl + V to paste it into any image editing software, then save the file.
  • Insert the screenshot directly into your Excel workbook:
    1. Press Ctrl + V to paste the screenshot.
    2. Click on the pasted image and go to the Home tab.
    3. In the Editing group, click on Copy, then click on Move.
    4. Now, you can resize and place the image as desired in your workbook.

Capturing Screenshots on Mac

If you're using a Mac, the keyboard shortcuts are slightly different:

AD
  • Command + Shift + 3 for a full-page screenshot.
  • Command + Shift + 4, then drag the crosshair to select a specific area for a custom screenshot.

Using the Snipping Tool

Windows comes with a built-in Snipping Tool that allows you to capture screenshots in various shapes and sizes.

To access the Snipping Tool:

  • Press Windows key + I to open Settings.
  • Click on Ease of Access.
  • Select Keyboard from the left-hand menu.
  • Under the Use the Print Screen key to open screen snipping section, turn on the ON button.

Now, whenever you press the Print Screen key, the Snipping Tool will open, allowing you to capture screenshots in four different styles: Free-form Snip, Rectangular Snip, Window Snip, and Full-screen Snip.

AD

Customizing the Snipping Tool

To set the Snipping Tool as your default screen capture method:

  • Open the Snipping Tool.
  • Go to the Options tab.
  • Under Output to, select File and choose a save location.
  • Click on the New button to start capturing screenshots.

Congratulations! Now you know how to take screenshots in Excel like a pro. Whether you're using keyboard shortcuts or the Snipping Tool, capturing and sharing Excel screenshots has never been easier. Happy screenshot-taking!

AD