Mrinmoy Roy
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 having any further discussion, let’s get straight into it.
Download Practice Workbook
You can download the Excel file from the following link and practice along with 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 allows you to 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:
2 Ways to Remove Page Number from Page Break Preview in Excel
1. Using Ribbon to Remove Page Number 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
- In the Worksheet Views group, select the Normal
So the default Worksheet Views mode will be activated. Thus, the page number will be no more.
Read More: How to Use Formula for Page Number in Excel (6 Quick Ways)
Similar Readings
- How to Insert Page Number in Excel (7 Easy Methods)
- Insert Page Number Using VBA in Excel (3 Macros)
- How to Show Page Number in Excel Background (2 Ways)
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.
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
- 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 be disappeared. Now your worksheet will look like the default version.
Read More: How to Change Page Number in Excel (With Easy Steps)
Practice Section
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.
Conclusion
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 asap. And please visit our website Exceldemy to explore more.
