Excel page numbers appear only in print preview and printed output, not on screen

Page numbers in Excel do not show up while you are working on your spreadsheet. They only appear when you print the document or view it in print preview. Excel adds them through the header and footer area — a section that sits at the top or bottom of each printed page but stays hidden during normal editing.

The process differs slightly depending on whether you use Excel on Windows, Mac, or the web version. All three methods involve the same basic steps: opening the page setup area, choosing where you want the page number (header or footer), and selecting a format.

Key Takeaways

  • Page numbers in Excel only print or appear in print preview — they do not show on your screen while editing.
  • You add page numbers through the header and footer settings, found in the Insert menu or Page Layout tab depending on your version.
  • Excel offers preset formats like "Page 1 of 5" or lets you type custom text alongside the page number.
  • You can place page numbers in the header (top of page) or footer (bottom of page), and left, center, or right aligned.
  • After adding page numbers, use print preview to confirm they appear correctly before printing.

Adding page numbers in Excel on Windows

Open your spreadsheet and go to the Insert tab at the top of the ribbon. Look for the Header & Footer button, usually on the right side of the ribbon. Click it, and Excel will switch to a special page layout view where you can edit headers and footers.

You will see three sections at the top of the page: left, center, and right. Click in the section where you want the page number to appear. Then go back to the Insert tab (it remains available while you are in this view) and click the Page Number button. Excel inserts a code like &[Page] into that section. Click outside the header area when you are done, and Excel returns to normal view.

If you want page numbers in the footer instead, click in the footer area at the bottom of the page before inserting the page number code. The process is identical — just the location changes.

Adding page numbers in Excel on Mac

Open your spreadsheet and click the Insert menu at the top. Select Header and Footer from the dropdown. Excel opens the page setup dialog box.

In the dialog, you will see tabs for Header and Footer. Click whichever one you prefer. Then click the button labeled Page Number (or sometimes #). Excel inserts the page number code into that section. You can also type text before or after the code — for example, typing "Page " before the code produces "Page 1", "Page 2", and so on.

Click OK to close the dialog and return to your spreadsheet.

Adding page numbers in Excel online

Excel on the web has limited header and footer options compared to the desktop versions. Open your spreadsheet and click Insert in the ribbon. Look for Header & Footer or Print Layout options — the exact name varies depending on your version.

If your version does not offer this feature directly, download the file to your computer, add the page numbers using the Windows or Mac instructions above, and then upload it back to the web. This is the most reliable way to ensure page numbers appear correctly when you print from the web version.

Using preset page number formats

Excel offers several built-in formats beyond just the page number itself. When you click the Page Number button, you often see options like Page 1, Page 1 of 5, or # (just the number). Choose the format that matches what you want to print.

If none of the presets fit your needs, you can type custom text around the page number code. For example, in the center footer section, you might type "Sheet 1 — Page &[Page]" to produce "Sheet 1 — Page 1", "Sheet 1 — Page 2", and so on. The &[Page] code always represents the current page number, no matter what text surrounds it.

Checking your page numbers before printing

After you add page numbers, use print preview to confirm they appear where you expect. On Windows, click File, then Print, and the preview pane on the right shows how your pages will look. On Mac, click File, then Print Preview. Use the navigation arrows to flip through pages and verify the page numbers are correct.

If the page numbers do not appear in preview, go back and check that you inserted them in the header or footer, not in a cell on the spreadsheet itself. Also confirm that your print area is set correctly — if you have limited the print area to specific cells, pages outside that area will not print and will not have page numbers.

Removing or editing page numbers

To remove page numbers, open the header and footer area again (using the same Insert menu or tab you used to add them). Click in the section containing the page number code and delete the &[Page] text. You can leave any surrounding text if you want — for example, if you typed "Page &[Page]", deleting just the code leaves "Page " behind.

To change the format or location, delete the current page number code and insert a new one in a different section or with different surrounding text. You can have page numbers in multiple places — for instance, in both the header and footer — if you insert the code in more than one section.

Frequently Asked Questions

Why do not my page numbers show up on screen?

Page numbers in Excel only appear in print preview and on printed pages. They live in the header and footer area, which is hidden during normal editing. Switch to print preview to see them before you print.

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

Yes. On Windows, go to Page Layout tab, click Page Setup, and find the Page tab. Look for a field labeled First page number and enter the number you want. On Mac, this option is in the header and footer dialog under Page Number settings.

Can I have different page numbers on different sheets?

Each sheet in your workbook has its own header and footer settings. Add page numbers to each sheet separately, and they will number independently. If you want continuous numbering across all sheets, you will need to print all sheets at once and manually adjust the starting number on each sheet.

What if I only want page numbers on some pages?

Excel applies headers and footers to all pages in the print area. To skip page numbers on certain pages, you would need to print those pages separately without the header and footer, or use a different approach like adding page numbers manually in a text box on specific sheets.

Do page numbers print if I print to PDF?

Yes. When you print your spreadsheet to a PDF file, the page numbers from your header and footer will appear in the PDF just as they would on a printed page.