This article explains page numbering in Excel 365 - 2010. Find out how to insert page numbers in Excel if your workbook contains one or multiple worksheets, how to set a custom number for the starting sheet or delete number watermarks added incorrectly.
When you print an Excel document, you may want to display numbers on the pages. I'll show you how to put page numbers in Excel. It's possible to add them in the sheet's header or footer. You can also select if they will appear in the left, right or central part.
You can insert numbers using the Page Layout view and the Page Setup dialog box. These options allow adding page numbers for one or several worksheets. You can also define any number for your starting sheet if the default settings don't work for you. Please also remember that you can always see how your printed pages will look in the Print Preview mode.
Page markers are really useful if your worksheet is quite big and prints as multiple pages. You can put page numbers for a single spreadsheet using the Page Layout view.
Tip. You can also click on the Page Layout Button image on the status bar in Excel.
Both header and footer areas have three sections: left, right and center. You can choose any by clicking on the correct section box.
Now you can reset back to Normal view if you click on the Normal icon under the View tab. You can also press Normal Button image on the status bar.
Now, if you go to Print Preview, you will see the page number watermarks added in Excel according to the selected settings.
Tip. You can also apply any watermarks to your sheets using the HEADER & FOOTER TOOLS, please see How to Add a Watermark to a Worksheet in Excel.
Say, you have a workbook with three sheets. Each sheet contains pages 1, 2, and 3. You can insert page numbers on multiple worksheets so that all pages are numbered in sequential order by using the Page Setup dialog box.
Now if you go to the Print Preview pane, you'll see that all pages from all worksheets got sequential Excel page number watermarks.
By default, pages are numbered sequentially starting with page 1, but you can start the order with a different number. It can be helpful if you printed one of your workbooks to realize a minute later that you needed to copy several more worksheets to it. Thus you can open the second workbook and set the first page number to 6, 7, etc.
Now you can easily print the second document with the correct page numbering.
By default, Excel prints pages from the top down and then left to right on the worksheet, but you can change the direction and print pages from left to right and then from the top down.
Suppose you got an Excel document with the page numbers inserted but don't need them to be printed. You can employ the Page Setup dialog box to remove page number watermarks.
Now you know how to insert page numbers in Excel on a single or multiple worksheets, how to put a different number on the starting page or change the order of page numbering. Finally, you can remove page number watermarks if you no longer need them in your document.
Feel free to let me know if you have any questions of difficulties. Be happy and excel in Excel!
Table of contents