How to Take a Screenshot in Excel
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.
For a full-page screenshot, press:
- Print Screen (PrtScn) key on your keyboard.
For an active window screenshot, press:
- 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:
- Press Ctrl + V to paste the screenshot.
- Click on the pasted image and go to the Home tab.
- In the Editing group, click on Copy, then click on Move.
- 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:
- 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.
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!