While working with Excel sheets, users often tend to prefer having page numbers to make the multiple sheets easier to manage. Page numbers are useful when you print multiple sheets. As a result, you will not have to face the wrong order of sheets in the end.
Sometimes, these page numbers are unwanted and you don’t need them to appear on the sheets. So, how to remove page numbering in Excel, do you have any idea?
Undoubtedly, page numbers are way more useful to keep your document organized. For many reasons, you may have to remove them from the file and it would be a tiring thing when the page numbers are not added by you. It would be difficult for you because you don’t know what else changes are linked with the removal of page numbers.
So, let’s have a look at the post to learn how you can do this easily.
How to Hide Page Number Watermark with Normal View
In case, you need to hide the page number watermark for some time, you have to switch Page Break Preview to Normal View. For this, follow the steps given below:
- Open the View tab.
- Click on the Normal option and you will see the page number watermark has gone.
- You will find the Normal button in the status bar as well. Click on it and switch to Normal view.
Page Number in Page Break Preview Mode
In Excel, when a worksheet appears in Page Break Preview you will see page breaks as dashed lines. Each page has by default the page numbers appearing in the center. In the following image, you can see how the page numbers in the Page Break Preview mode appear:
How to Remove Page Numbering in Excel with Page Break Preview in Excel
Below you will find two different methods to solve this query:
Removing Page Numbers from Page Break Preview with Ribbon
Follow the steps given below to remove the page numbers in the Page Break Preview mode:
- Open the View tab.
- Check if the Page Break Preview mode is activated in the Workbook Views menu.
- You need to switch from Page Break Preview mode to Normal Mode for the removal of Page numbers and for this:
- Open the View tab.
- Click on the Worksheet Views menu and choose the Normal option. The default worksheet view will appear and there will be no more page numbers on the sheet.
Remove Page Numbers from Page Break Preview with Status Bar
Using the Status Bar, you can easily remove the page numbers in the Page Break Preview mode. If the Page Break mode is activated your sheet will appear as the following image:
- On the bottom right side of the sheet, you can notice the Page Break Preview button, which is selected.
- Switch to the Normal mode to remove the page number.
And for this,
- Click on the Normal sheet view button.
- Now, you are switched to Normal mode from the Page Break Preview mode. All the page numbers will be removed from the sheet.
All done!
Summary:
You have got an answer to how to remove page numbering in Excel by using multiple approaches. This post has multiple solutions to easily remove the page numbers. You can try any of the above methods and the results will be the same all the time.
Excel has wide openings to sort out different queries, however, you need to practice the steps for a great outcome every time.
