Page Numbers


This example teaches you how to print page numbers in Excel.

1. On the View tab, click Page Layout, to switch to Page Layout view.

Switch to Page Layout View

2. Click to add footer.

Click to add footer

The Header & Tools contextual tab activates.

3. On the Design tab, click Page Number to add the page number.

4. Type " of "

5. On the Design tab, click Number of Pages to add the number of pages.

Add Number of Pages

Note: Excel uses codes in order to automatically update the header or footer as you change the workbook.

6. Click somewhere else on the sheet to see the footer.

Page Numbers in Excel

Note: on the Design tab, click Options for a different first page header/footer or a different header/footer for odd and even pages.

7. On the View tab, click Normal, to switch back to Normal view.

5/9 Completed! Learn much more about printing >
Back to Top: Page Numbers   |   Go to Next Chapter: Share