If you’re using Excel’s Page Break Preview to adjust your page breaks, you may find that the page numbers on the worksheet interfere with your making changes. Luckily, you can remove the page numbers from the view by following a few simple steps. In this article, I will guide you to remove the page number in Excel Page Break Preview mode in 2 simple ways. So, without further discussion, let’s get straight into it.
What Is Page Break Preview Mode in Excel?
If you work with large Excel worksheets, you know how frustrating it is to scroll back and forth between different areas of the sheet. Page Break Preview mode in Excel lets you see exactly where the pages will break when you print your document. This can be a huge time-saver when trying to format your worksheet for printing.
Your worksheet will shrink down to a fraction of its size and you’ll see the page breaks indicated by dotted lines. You can then click and drag the page breaks to adjust them as needed.
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. The page number in the Page Break Preview mode looks like the following picture:
How to Remove Page Number in Excel Page Break Preview: 2 Ways
1. Using Ribbon to Remove Page Number in Excel from Page Break Preview
To remove the page number in the Page Break Preview mode,
- Go to the View tab first.
There you will see that the Page Break Preview mode is selected in the Workbook Views group.
Now have to switch to Normal mode from Page Break Preview mode to remove the page number.
To do that,
- Go to the View tab.
- In the Worksheet Views group, select the Normal option.
So the default Worksheet Views mode will be activated. Thus, the page number will be no more.
2. Using Status Bar to Remove Page Number from Page Break Preview
You can also remove the page number in the Page Break Preview mode from the Status Bar.
If you are currently in the Page Break Preview mode, after selecting the View tab, your worksheet will look like the following picture.
Now check out the bottom-right corner of your Excel sheet, you will see that the Page Break Preview button is selected.
To remove the page number, you have to go to Normal mode.
For that, click on the Normal worksheet view button.
Now your worksheet view will switch from Page Break Preview mode to Normal mode.
Thus, the page number will be removed and your worksheet will look like the following picture.
Read More: How to Print Page Number in Excel
Remove Page Break Lines
After switching from the Page Break Preview mode to Normal mode, you will see the Page Break Lines on your worksheet.
To remove the lines,
- Go to the File tab.
- Then select the Options.
Now Excel Options dialog box will appear.
- Select the Advanced.
- Scroll down to the ‘Display options for this worksheet’.
- Uncheck ‘Show page breaks’.
- Then press OK.
Finally, the page breaks will disappear. Now your worksheet will look like the default version.
You will get an Excel sheet like the following screenshot, at the end of the provided Excel file where you can practice all the topics discussed in this article.
Download Practice Workbook
You can download the Excel file from the following link and practice along with it.
To sum up, I have discussed 2 ways to remove the page number from the page break preview in Excel. Please don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries
- How to Start Page Numbers at Different Number in Excel
- How to Insert Sequential Page Numbers Across Worksheets
- How to Insert Page Number in Excel
- How to Insert Page Number Using VBA in Excel
- How to Use Formula for Page Number in Excel