30 Advanced Excel Tips for 2026

Excel Champs / Excel Basics / Print Preview
By Puneet Gogia (Microsoft MVP)

How to Show the Print Preview in Excel

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

Press Ctrl + P or Ctrl + F2, or go to File → Print. Since Excel 2010 there is no separate Print Preview window: the preview fills the right of the Print screen and the print settings sit on the left.

The preview shows the active sheet by default. To preview only part of it, select those cells first and change the first drop-down under Settings to Print Selection; choose Print Entire Workbook to page through every sheet.

Use the page arrows at the bottom of the preview to move between pages. Show Margins at the bottom right lets you drag the margins, Zoom to Page toggles a close-up, and Esc takes you back to the sheet.

For a one-click button, add Print Preview and Print from the Customize Quick Access Toolbar drop-down. To see page edges while you keep editing, use View → Page Layout, or View → Page Break Preview to drag the page breaks.

If the preview shows columns spilling onto extra pages, change No Scaling to Fit All Columns on One Page rather than Fit Sheet on One Page, which shrinks long lists until they are unreadable. If it shows the wrong range, clear an old print area with Page Layout → Print Area → Clear Print Area.

Since Excel 2010, the print preview is part of the Print page (File ➜ Print), and the quickest way to open it is the keyboard shortcut Control + P (or Control + F2). It shows you a preview of the pages, and you can make changes to the settings before printing them out.

print-preview-page

In this tutorial, we will learn the use of the print preview function along with its settings and options in Excel.

Steps to Show Print Preview

There are two ways to do that:

1. From the File Tab on Ribbon

  • First, if you only want to print a part of the data, select it. Otherwise, you can simply click any cell in the sheet.
select-data-to-print
  • After that, click on the File tab, and from the list of options, select the Print option.
click-file-tab-and-select-print

2. Using a Keyboard Shortcut

You can also print the data by pressing the keyboard shortcut keys that are CTRL + P. Once you press these keys, it will directly open the print preview page.

Page Settings

1. Print Button

It is on the top-left side of the page. When you click it, it prints the pages that you see in the preview on the right side.

print-button

2. Copies

Here, you can specify the number of copies that you want to print.

add-number-of-copies

3. Printer

Select the printer that you want to use. If the printer is not available in the list, add it first.

4. Print Range Drop-down

  • Active Sheet: To print the active sheet, select Print Active Sheets from the print range drop-down and then click Print.
select-print-active-sheet
  • Print Entire Workbook: You have the option to print multiple worksheets altogether from a single workbook. And for this, you need to select Print Entire Workbook, as you see below.
click-when-print-entire-workbook
  • Print Selection: This option is specially used when you want to print a specific range of cells instead of an entire sheet. For this, you need to select the cells first and then click on Print Selection in the drop-down.
select-the-area-to-print

5. Page Orientation

  • Portrait Orientation: When you have data with more rows in the worksheet, then select portrait orientation as it will help you to fit all the rows on a single page.
portrait-orientation-page
  • Landscape Orientation: Just like more rows, the landscape orientation will help you to fit a large number of columns on a single page.
select-landscape-orientation-to-fit-columns

6. Paper Size

The next thing after selecting the page orientation is to select the size of the paper. The sizes are shown in inches or centimeters (based on your regional settings), and you have various options like Letter, A4, Legal, envelopes, and so on.

select-paper-size

7. Margins

It helps to set the margins of the sheet and the data from the top, bottom, left, right, header, and footer also. It has three presets, Normal, Wide, and Narrow, and you can also use Custom Margins to set them as per your needs.

margins-of-the-page

8. Scaling

This feature is used to make some adjustments to fit your data on the page so that it would not be cut off by the printer while printing. In the scaling drop-down, you have four options: No Scaling, Fit Sheet on One Page, Fit All Columns on One Page, and Fit All Rows on One Page, plus Custom Scaling Options.

In the following example, we have selected the Fit Sheet on One Page option to fit the entire data into a single page. But in this case, the data has shrunk so much that it is difficult to read. For a big sheet, Fit All Columns on One Page is often the better choice.

scaling-to-fit-sheet-on-one-page

Below the scaling options, there’s a Page Setup link. It opens the Page Setup dialog box, where you get more settings, like headers and footers, print titles, gridlines and centering the data on the page.

Buttons at the Bottom of the Print Preview

  • Page navigation: at the bottom left, use the arrows (or type a page number) to move between the pages of the preview.
  • Show Margins: at the bottom right, this button shows the margin lines, and you can drag them with the mouse to change the margins.
  • Zoom to Page: next to it, this button zooms in and out of the preview page so you can check the details.

Other Ways to See How Your Sheet Will Print

Apart from the print preview, the View tab has two more views. Page Layout view shows the pages with their margins, headers and footers while you keep editing the data, and Page Break Preview shows where each page starts and ends, so you can drag the page breaks.

If you open the print preview often, you can add the “Print Preview and Print” command to the Quick Access Toolbar to open it with one click. On a Mac, press Command + P to open the Print dialog with its preview.

Frequently Asked Questions

Why does the print preview show a blank page?

Usually, the print area is set on an empty range, or the selection is printed instead of the sheet. Check the first setting under Settings (Print Active Sheets) and clear the print area with Page Layout ➜ Print Area ➜ Clear Print Area.

Why is the print preview not available?

The print preview needs a printer. If no printer is installed, add one (Microsoft Print to PDF works) in your computer’s printer settings, and the preview will show up.

Can I edit the data in the print preview?

No, the print preview is read-only. Press Esc or the back arrow to go back to the sheet, make the changes, and open the preview again.

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel