Print Preview in Excel (Shortcut)

In Excel, the Print Preview is a view that shows how your spreadsheet will look when it is printed.

Print Preview screen would show you all the data and formatting that you have applied to your data, as well as the page layout and any headers or footers that you have specified.

When you are satisfied with how your spreadsheet will look when it is printed, you can click the Print button to send it to your printer.

In this tutorial, I will give you the keyboard shortcut to get the Print Preview in Excel

Shortcut to Print Preview in Excel

Below is the keyboard shortcut to Print Preview in Excel:

Control + P

How to Use the Keyboard Shortcut to Print Preview in Excel

Below are the steps to use the above keyboard shortcut:

  1. Activate the worksheet for which you want to see the Print Preview screen
  2. Hold the Control Key
  3. Press the P key

The above steps would open the Print Preview screen in Excel and show you what the printed data would look like when printed.

Print Preview screen

Note: The above keyboard shortcut also works in other Microsoft Office applications such as MS Word and MS PowerPoint

Important Things to Know About Print Preview in Excel:

  • If you have multiple pages that would be printed, you can see all these pages one by one by clicking on the arrow icon at the bottom-center of the print preview window
  • If you have inserted any headers or footers in the worksheet, you would be able to see these in the print preview window.
  • In the print preview option, you get to choose from the three print options – Print Active Sheets only, Print the entire workbook, or print selection only

Alternate Ways to Open Print Preview Window in Excel:

  • You can also open the Print Preview window by using the keyboard shortcut ALT + F + P
  • Another to open the print preview window is by clicking on the File tab in the ribbon, and then clicking on the Print option
Click the Print option in the File tab

Other Excel shortcut articles you may also like:

Other Excel Articles You May Also Like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

Leave a Comment