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

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

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

Read More: How to Insert Page Number in Excel Cell Not in Header


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

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.

Remove Page Break Lines

Finally, the page breaks will disappear. Now your worksheet will look like the default version.


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.


Download Practice Workbook

You can download the Excel file from the following link and practice along with it.


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


Related Articles


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mrinmoy Roy
Mrinmoy Roy

Mrinmoy Roy, a dedicated professional with a BSc in Electronics and Communication Engineering from Khulna University of Engineering & Technology, Bangladesh, brings over two years of expertise to the ExcelDemy project. As a prolific contributor, he has authored around 180 articles, showcasing his deep knowledge and passion for Microsoft Excel, Data Analysis, and VBA. His unwavering commitment to continuous learning, combined with versatile skills, renders him well-suited for roles in data management and spreadsheet solutions. He has interest... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo