Subscribe

Lesson 85 of 104 2 min Updated Completed

How to Insert Page Numbers in Excel

Page numbers make a printed sheet with several pages easier to follow. Here’s how to add them to the footer.

  1. Click View > Page Layout.

    The Page Layout button on the View tab

  2. Scroll down and click Add footer at the bottom of the page.

  3. On the Header & Footer tab, click Page Number.

    Adding a page number from the Header & Footer tab

    Excel adds a code, &[Page], which shows the right number on each page. For Page 1 of 5, type Page, click Page Number, type of, then click Number of Pages.

  4. Click anywhere in the sheet to see the page number.

    The page number shown in the footer

  5. To leave the number off the first page (for a cover page, say), tick Different First Page on the Header & Footer tab.

    The Different First Page option

  6. To go back to the normal view, click View > Normal.

    The Normal button on the View tab

Tip: To check the page numbers, click File > Print (Ctrl + P).