#Auto page numbering in word 2016 how to

You can choose any by clicking on the correct section box. You'll get the Design tab with Header & Footer Tools.īoth header and footer areas have three sections: left, right and center.Click within the field Click to add header or Click to add footer. You will see your worksheet in the Page Layout view.You can also click on the Page Layout Button image on the status bar in Excel. Go to the Insert tab and click on the Header & Footer in the Text group.Open your Excel worksheet that needs inserting page numbers.You can put page numbers for a single spreadsheet using the Page Layout view. Page markers are really useful if your worksheet is quite big and prints as multiple pages. Insert page numbers in Excel on one worksheet Change the order in which page numbers are added.Customize page numbering for the starting page.

#Auto page numbering in word 2016 how to

How to put page numbers in multiple Excel worksheets.

Insert page numbers in Excel on one worksheet.Please also remember that you can always see how your printed pages will look in the Print Preview mode. You can also define any number for your starting sheet if the default settings don't work for you. These options allow adding page numbers for one or several worksheets. You can insert numbers using the Page Layout view and the Page Setup dialog box. You can also select if they will appear in the left, right or central part. It's possible to add them in the sheets' headers or footers. I'll show you how to put page numbers in Excel. When you print an Excel document, you may want to display numbers on the pages. 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.

This article explains page numbering in Excel 2019, 2016-2010.