How to Insert Page X of Y into a Header or Footer in Excel Lori Kaufman @howtogeek October 14, 2015, 10:24am EDT If you have a large spreadsheet in Excel, you may want to add page numbers. Google phone app for mac.

This article explains page numbering in Excel 2019, 2016-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.

Code for virtualbox. I'll show you how to put page numbers in Excel. It's possible to add them in the sheets' headers or footers. 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.

• • • • • Insert page numbers in Excel on one worksheet 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. • Open your Excel worksheet that needs inserting page numbers.

• Go to the Insert tab and click on the Header & Footer in the Text group. You can also click on the Page Layout Button image on the status bar in Excel. • You will see your worksheet in the Page Layout view. Click within the field Click to add header or Click to add footer. • You'll get the Design tab with Header & Footer Tools. Both header and footer areas have three sections: left, right and center. You can choose any by clicking on the correct section box.

• Go to the Header & Footer Elements group and click on the Page Number icon. • You'll see the placeholder &[Page] appear in the selected section. • If you want to add the total number of pages, type a space after &[Page]. Then enter the word ' of' followed by a space.

Please have a look at the screenshot below. • Click the Number of Pages icon in the Header & Footer elements group to see the placeholder &[Page] of &[Pages] in the selected section. • Click anywhere outside the header or footer area to display the page numbers.

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. You can also apply any watermarks to your sheets using the HEADER & FOOTER TOOLS, please see.