Excel doesn't add page numbers the way Word does

Excel doesn't have a straightforward "insert page number" button like Word. Instead, page numbers live in the header and footer — the space at the very top and bottom of each printed page. To add them, you go through the Insert menu, not the main spreadsheet itself. The page numbers won't show on your screen while you work; they only appear when you print or preview the document.

This matters because Excel treats page numbers differently depending on whether you're printing one sheet or multiple sheets, and whether you want the same number on every page or a running count. The steps are straightforward once you know where to look.

Key Takeaways

  • Page numbers in Excel go in the header or footer, accessed through the Insert menu, not directly on the spreadsheet.
  • You must be in Page Layout view or use the Page Setup dialog to add headers and footers — they won't appear in Normal view.
  • Excel can automatically number pages sequentially across multiple sheets, or restart numbering on each sheet.
  • Page numbers only show when you print or use Print Preview; they don't display while you're working in the spreadsheet.

Adding page numbers through the header and footer

Open your spreadsheet in Excel. Go to the Insert tab at the top of the screen. On the right side of the ribbon, you'll see a section labeled Header & Footer. Click Header or Footer depending on where you want the page number to appear.

A dropdown menu will open with preset options. The third option down usually says something like &[Page] — that's the automatic page number. Click it. Excel will insert a code that represents the page number. You'll see the text change to show you've added it, though it may look like a placeholder rather than an actual number at this stage.

Once you've selected a header or footer option with a page number, click somewhere else on the spreadsheet to close the header and footer area. The page number code is now set. To see what it will look like when printed, go to File > Print and look at the preview on the left side of the screen.

Using Page Layout view for more control

If the dropdown options don't give you what you want — for example, if you want "Page 1 of 5" instead of just "1" — switch to Page Layout view. This view shows you exactly how the page will look when printed, including the header and footer areas.

Click the View tab, then select Page Layout. The spreadsheet will now display with visible margins and header/footer space at the top and bottom. Click directly in the header or footer area (you'll see it's now clickable), and type or paste your text. To insert an automatic page number, click Insert > Header & Footer > Page Number while your cursor is in the header or footer box.

Page Layout view also lets you see how your data will break across pages, which is useful if you're trying to fit a spreadsheet neatly onto printed sheets. When you're done, switch back to Normal view from the View tab.

Numbering multiple sheets separately or continuously

If your workbook has several sheets and you want each one to start at page 1, add the page number to each sheet individually. Go to each sheet tab at the bottom, then repeat the header/footer steps above. Each sheet will restart its numbering at 1.

If you want continuous numbering across all sheets — so sheet two starts at page 6 if sheet one ended at page 5 — you'll need to use a workaround. In the header or footer, type text like "Page" followed by the page number code, then manually adjust the starting page number for each sheet. Go to File > Print, click Print Setup or Page Setup, find the Sheet tab, and look for a field labeled First page number. Enter the number you want that sheet to start with.

This approach is more manual, but it's the standard way to achieve continuous numbering across multiple sheets in Excel.

Removing or editing page numbers

To remove page numbers, go back to Insert > Header & Footer and select the (none) option at the top of the dropdown. This clears the header or footer entirely.

To edit what's already there — for example, to change "Page 1" to "Sheet 1, Page 1" — switch to Page Layout view, click in the header or footer area, and edit the text directly. You can keep the page number code and add regular text around it. When you print, Excel will replace the code with the actual number.

Checking your work before printing

Always preview your spreadsheet before you print. Go to File > Print and look at the preview pane on the left. Scroll through the pages using the arrow buttons to make sure the page numbers appear where you expect them and that your data breaks across pages the way you want.

If the page numbers are cut off or in the wrong position, go back to File > Page Setup, click the Margins tab, and adjust the top or bottom margin to give the header or footer more room. A margin of at least 0.5 inches usually works well for headers and footers.

Why page numbers don't show in Normal view

Excel's Normal view is designed for data entry and editing, not for seeing how the page will look when printed. Headers and footers are printing features, so they're hidden by default in Normal view. This is intentional — it keeps your working view clean and uncluttered.

If you want to see headers and footers while you work, switch to Page Layout view. If you only want to see them once before printing, use Print Preview. Both approaches show you exactly what will appear on the printed page.

Frequently Asked Questions

Can I have different page numbers on different sheets?

Yes. Each sheet has its own header and footer settings. Go to each sheet tab and add the page number separately. By default, each sheet will restart numbering at 1. If you want each sheet to continue from where the last one ended, use the First page number setting in Page Setup for each sheet.

What if I want "Page 1 of 10" instead of just the number?

In Page Layout view, click in the header or footer and type "Page " (with a space). Then go to Insert > Header & Footer > Page Number. Type " of " and then go to Insert > Header & Footer > Pages (the total page count). Excel will fill in the numbers automatically when you print.

Do page numbers print if I print to PDF?

Yes. When you export or print to PDF, Excel includes the headers and footers exactly as they appear in Print Preview. The page numbers will be part of the PDF file.

Why are my page numbers showing as codes like &[Page] instead of actual numbers?

You're looking at the spreadsheet in Normal view or Page Layout view while editing. The codes are placeholders that Excel replaces with real numbers when you print or preview. Switch to Print Preview or print the document to see the actual numbers.

Can I add page numbers only to certain pages?

Not selectively within a single sheet. Excel applies the header and footer to all pages of a sheet. If you need page numbers on some pages but not others, you would need to split the data into separate sheets and add headers only to the sheets that need them.