How to Remove Page Number from Page Break Preview in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.

Using Ribbon to Remove Page Number from Page Break Preview in Excel

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.

Using Ribbon to Remove Page Number from Page Break Preview in Excel

Read More: How to Use Formula for Page Number in Excel (6 Quick Ways)


Similar Readings


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.

Using Status Bar to Remove Page Number from Page Break Preview in Excel

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.

Using Status Bar to Remove Page Number from Page Break Preview in Excel

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.

Using Status Bar to Remove Page Number from Page Break Preview 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

  • 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.

Remove Page Break Lines

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.


Related Articles

Mrinmoy Roy

Mrinmoy Roy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo