How to Remove the Page Number from the Page Break Preview in Excel

What Is Page Break Preview Mode in Excel?

Page Break Preview mode in Excel shows page breaks indicated by dotted lines indicating where the pages will break when you print your document.

Page Number in Page Break Preview Mode

When you view a worksheet in Page Break Preview, Excel displays page breaks as dashed lines. By default, the page number appears at the center of each page.

Method 1 – Using the Ribbon to Remove the Page Number in from the Page Break Preview

Go to the View tab first.

The Page Break Preview mode is selected in Workbook Views.

Switch to Normal mode to remove the page number.

Go to the View tab.
In Worksheet Views, select Normal.

The default Worksheet Views mode will be activated. The page number will no longer be displayed.

Method 2 – Using the Status Bar to Remove the Page Number from the Page Break Preview

If you select the View tab in Page Break Preview mode, your worksheet will look display the page number.

At the bottom-right corner of your Excel sheet the Page Break Preview button is selected.

To remove the page number, go to Normal mode.

Click the Normal worksheet view button.

Your worksheet view will switch from Page Break Preview to Normal mode.

The page number will be removed.

Read More: How to Print Page Number in Excel

Remove Page Break Lines

After switching from the Page Break Preview to Normal mode, you will see Page Break Lines.

To remove the lines:

Go to the File tab.

Select Options.

In the Excel Options dialog box:

Select Advanced.
Choose ‘Display options for this worksheet’.
Uncheck ‘Show page breaks’.
Press OK.

This is the output.

Practice Section

Practice here.

Download Practice Workbook

Download the Excel file here.

Remove Page Number.xlsx

<< Go Back to Page Number | Page Setup | Print in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

How to Remove the Page Number from the Page Break Preview in Excel – 2 Methods