How to Add Page Numbers in Excel (Print Headers, Footers & More)

Page numbers don't appear on an Excel spreadsheet the way they do in Word — and that trips up a lot of people. Excel is built around a grid, not pages, so numbering works through a separate system tied to printing and print preview. Once you know where to look, the process is straightforward. But how you set it up — and which method works best — depends on what you're actually trying to do with the document.

Why Excel Handles Page Numbers Differently

In a word processor, every page is a discrete unit. Excel's grid can theoretically stretch across hundreds of columns and thousands of rows, so "pages" only become relevant when you're preparing a spreadsheet for print or PDF export. Page numbers live in the header and footer layer — a separate zone that sits above or below the printable content and only becomes visible in certain views.

This matters because if you're just working in a normal spreadsheet view and expecting to see page numbers on screen, you won't — unless you switch to the right display mode.

The Three Main Ways to Add Page Numbers

1. Using Page Layout View (The Most Intuitive Method)

This is the most visual approach and works well for people who want to see exactly how the document will look when printed.

• Go to the View tab in the ribbon
• Click Page Layout (not to be confused with the Page Layout tab in the main ribbon)
• You'll see your spreadsheet split into pages with margins visible
• Click the area at the top or bottom that reads "Click to add header" or "Click to add footer"
• The header/footer zone splits into three sections: left, center, and right
• Click the section where you want the page number to appear
• In the Header & Footer tab that appears in the ribbon, click Page Number

Excel inserts &[Page] as a code. When printed or previewed, this renders as the actual page number. You can combine it with other text — for example, typing Page &[Page] of &[Pages] gives you "Page 1 of 4" style numbering.

2. Using the Page Setup Dialog Box

This approach gives you more control, especially if you want to set page numbers before committing to a layout.

• Go to the Page Layout tab in the ribbon
• Click the small arrow icon at the bottom-right corner of the Page Setup group to open the dialog box
• Click the Header/Footer tab
• Use the dropdown menus for preset options (like "Page 1", "Page 1 of ?", "Confidential, Page 1")
• Or click Custom Header or Custom Footer for manual control
• In the custom editor, use the insert page number button (the icon showing #) to place &[Page] in any section

This method is particularly useful when you want to apply page numbers to multiple sheets at once — select multiple sheet tabs before opening Page Setup and the formatting applies to all of them.

3. Using the Insert Tab

• Go to Insert in the ribbon
• Click Text, then Header & Footer
• This switches you into Page Layout view automatically and places your cursor in the header
• From there, use the Header & Footer Elements group to insert &[Page]

This route is functionally the same as Method 1 but accessed from a different part of the ribbon. 📄

Controlling Where Page Numbers Start

By default, Excel starts numbering at 1. But if your spreadsheet is part of a larger document — say, the second section of a multi-file report — you may want it to start at a different number.

• Open Page Setup (Page Layout tab → Page Setup dialog)
• Go to the Page tab
• Find the "First page number" field
• Change it from Auto to whatever number you need

Setting this to 5, for example, means the first printed page of that sheet will show as page 5.

Variables That Affect How Page Numbers Behave

Not everyone's experience with Excel page numbers looks the same. A few key factors change what you'll see and how you'll work with the feature:

What "Page X of Y" Actually Counts

One point of confusion worth clarifying: &[Pages] — the "total pages" code — counts only the pages in the current worksheet, not the entire workbook. If you have five sheets and want a continuous page count across all of them, you'd need to manually set the "First page number" on each sheet to pick up where the previous one left off.

This is a common friction point for people assembling multi-sheet reports. 🖨️

When Page Numbers Don't Show Up

If you've added page numbers but can't see them, you're likely still in Normal view. Page numbers only appear in:

• Page Layout view
• Print Preview (File → Print)
• The printed or exported PDF output

Switching to Normal view hides the header/footer layer — the numbers are still there, they're just not displayed in that mode. This is by design, keeping the grid clean during regular data entry.

How Print Settings Interact With Page Numbers

Scaling and fit-to-page settings can significantly change how many pages a spreadsheet produces — and therefore how many page numbers appear. If you've set Excel to "Fit Sheet on One Page", it will compress everything down, and you'll only ever see page 1. Conversely, if scaling is set to a small percentage, a modest spreadsheet might print across dozens of pages.

This means the page number output you see in Print Preview is only accurate relative to your current print settings. Change the margins, scaling, or print area, and the page count — and numbering — shifts accordingly. ⚙️

The Part That Depends on Your Setup

The mechanics of inserting page numbers are consistent across Excel versions. But whether you need a simple "Page 1" footer, a running "Page X of Y" count, cross-sheet numbering continuity, or page numbers starting mid-sequence — those decisions hinge entirely on what the spreadsheet is for, who's reading it, how it's being printed or shared, and how your specific workbook is structured. The same feature, applied differently, produces very different results depending on those factors.