Where to find the page number tool in Excel

Page numbers in Excel live in the Header & Footer section, which you reach through the Insert tab. Click Insert at the top of the ribbon, then look for Header & Footer in the Text group on the right side. This opens a design mode where you can add numbers, dates, file names, or sheet names to the top or bottom of every printed page.

The header and footer tools work the same way in Excel 2016, 2019, 2021, and Microsoft 365. If you are using Excel on a Mac, the location is identical — the Insert tab contains the same Header & Footer button.

Key Takeaways

  • Page numbers appear only when you print or export to PDF — they do not show on your screen while editing.
  • You add them through Insert > Header & Footer, then choose left, center, or right position for the footer or header.
  • Excel can automatically number pages as "Page 1 of 5" or just show the current page number, and you can add text before or after the number.
  • Page breaks in Excel do not always match what you expect on screen, so preview your print layout before printing to see where numbers actually land.

The three-section footer layout

When you click Header & Footer, Excel divides the footer (or header) into three zones: left, center, and right. You can put a page number in any of these zones, or in multiple zones at once. Most people put the page number in the center or right footer so it does not crowd other information.

Click in the section where you want the number to go. Then look for the Page Number button in the ribbon — it inserts a code that Excel reads as "put the current page number here." If you want the number to say "Page 1" instead of just "1", type the word "Page " first, then click the Page Number button, then type any text after it.

You can also add the total page count. Click the # button (which represents page count) after the page number button to create "Page 1 of 5" automatically. Excel updates this count based on how many pages your data actually fills when printed.

Seeing where page numbers will actually appear

Page numbers do not show on your normal spreadsheet view — they only appear when you print or save as PDF. To see where they will land, go to File > Print and look at the preview on the right side of the screen. This shows you exactly how many pages your data will fill and where the page numbers sit on each one.

If your spreadsheet is wider than one page or taller than one page, Excel breaks it across multiple sheets when printing. The preview tells you whether your data breaks at awkward spots — for example, whether a table splits across two pages in a way that makes it hard to read. You can adjust page breaks manually by going to Page Layout > Breaks if you want to control where the split happens.

Adding dates, file names, or sheet names alongside page numbers

The Header & Footer design mode includes buttons for other information you might want on every page. The Date button inserts today's date (or the date the file was last printed). The Time button adds the current time. The File Name button shows the name of your Excel file, and the Sheet Name button shows which sheet you are on — useful if your workbook has multiple sheets and you print them all at once.

You can combine these with page numbers. For example, you might put the file name in the left footer, the page number in the center, and the date in the right footer. Each piece of information updates automatically, so if you rename the file or print on a different day, the headers and footers change without you having to edit them.

Removing page numbers or changing them later

To remove page numbers, go back to Insert > Header & Footer, click in the section that contains the page number, select all the text in that section (Ctrl+A on Windows, Command+A on Mac), and delete it. Then click outside the header and footer area to exit design mode.

If you want to change where the page number sits — moving it from the footer to the header, for example — delete it from the current location and click in the new location, then insert it again. You can also edit the text around the number without removing the number itself. For instance, if you have "Page 1" and want it to say "Sheet 1, Page 1", just click before the page number code and type the new text.

Headers and footers on the first page or specific sheets

By default, page numbers appear on every page, including the first one. If you want to hide the header and footer on the first page only — a common choice for reports that have a title page — go to Page Layout > Page Setup, click the Header/Footer tab, and check the box that says Different first page. Then go back to Insert > Header & Footer, and the first page section will be empty while other pages keep their numbers.

If your workbook has multiple sheets and you want different page numbering for each sheet, you have to set them up separately. Add page numbers to the first sheet, then move to the second sheet and repeat the process. Excel does not automatically carry header and footer settings from one sheet to another, so each sheet starts with a blank header and footer unless you add content to it.

Frequently Asked Questions

Why do not my page numbers show when I look at my spreadsheet?

Page numbers only appear when you print or export to PDF. They are not visible in the normal editing view. To see them, go to File > Print and look at the preview on the right, or print to PDF to view the result.

Can I start page numbering from a number other than 1?

Yes. Go to Page Layout > Page Setup, click the Sheet tab, and enter a number in the "First page number" field. This tells Excel to start counting from that number instead of 1, useful if you are printing sections of a larger document separately.

What if my data spans multiple columns and pages when printed?

Excel will print across columns first, then down to the next set of rows. The page number appears on every page. Use the Print preview to see the actual layout, and adjust page breaks manually if needed through Page Layout > Breaks to control where splits occur.

Can I put page numbers in different places on different pages?

No. The header and footer settings explore to all pages in that sheet. However, you can use the "Different first page" option to leave the first page blank while numbering the rest, or set up different headers and footers on different sheets within the same workbook.

Do page numbers print if I print to PDF instead of paper?

Yes. Page numbers appear in PDF files the same way they appear on printed paper. The header and footer settings you create in Excel carry over to the PDF, so you can verify the layout by saving as PDF before printing to paper.