Excel guide · 5 min read
How to add page numbers in Excel
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Sheet | Pages | First page number | Footer to type |
| 2 | Summary | 1 | 1 | Page &[Page] of 10 |
| 3 | January | 3 | 2 | Page &[Page] of 10 |
| 4 | February | 2 | 5 | Page &[Page] of 10 |
| 5 | March | 4 | 7 | Page &[Page] of 10 |
| 6 | ||||
| 7 | Total pages | 10 |
Download this sheet as an Excel practice file (.xlsx)
Add "Page 1 of 3" to the footer
Page numbers in Excel live in the header or footer, not in cells. Excel works them out when it prints, so they always match the real page breaks. The sample is a quarterly workbook with a Summary sheet and three monthly sheets that will be printed and stapled together.
- Click the sheet you want to number.
- Go to Insert > Header & Footer. Excel switches to Page Layout view.
- Scroll to the bottom of the page and click the left, center or right footer box (the center one says Add footer).
- Type Page and a space, then click Page Number on the Header & Footer tab. The box shows Page &[Page].
- Type a space, the word of, and a space, then click Number of Pages. The box now reads Page &[Page] of &[Pages].
- Click any cell on the sheet. The codes turn into real numbers: Page 1 of 3, Page 2 of 3, and so on.
- Go back with View > Normal when you're done.
The quick way: a ready-made footer
If you don't need custom wording, use a built-in one. While you're in a header or footer box, the Header & Footer tab has Header and Footer drop-downs on the left with ready-made options such as Page 1 and Page 1 of ?. The same lists are in Page Layout > Page Setup dialog launcher > Header/Footer tab, which is also where you add page numbers to chart sheets.
Other buttons on the same tab add the current date, time, file name, sheet name or file path. A footer like "Page 1 of 3, January, printed 9 Nov" helps anyone who drops the pile on the floor. If your text needs an ampersand, type it twice (R&&D prints as R&D), because a single & starts a code.
"I added page numbers but I can't see them"
That's normal. Headers and footers don't show in Normal view, which is where most people work. Microsoft says they're shown only in Page Layout view, Print Preview and on printed pages. Check with the Page Layout button on the status bar (bottom right) or Ctrl+P.
If they're missing from Print Preview too, check that you clicked out of the footer box before printing, that you added them to the sheet you're actually printing, and that the footer isn't pushed off the page by tiny bottom margins. Page Setup > Margins shows the footer distance.
Start at a number other than 1
When your sheet comes after other pages, for example a two-page Word cover letter, start the numbering at 3. The setting is per sheet.
- Page Layout > Page Setup dialog launcher (the small arrow in the corner of the Page Setup group).
- On the Page tab, type 3 in First page number.
- Click OK. To go back to normal numbering, type Auto in the same box.
Number several sheets in one sequence
Each sheet numbers its own pages from 1. Microsoft's instructions say that adding page numbers to two two-page sheets at once still gives 1, 2 and 1, 2. To number the whole pack 1 to 10, give each sheet its own First page number. A small print plan does the arithmetic: read each sheet's page count from Print Preview (it shows "1 of 3" under the preview), and each first page is the previous first page plus the previous sheet's pages.
- To add the same footer to every sheet at once, right-click a tab > Select All Sheets.
- Page Layout > Page Setup dialog launcher > Header/Footer tab > Custom Footer, and build the footer with the Insert Page Number button.
- Right-click a tab > Ungroup Sheets. Then set First page number on each sheet separately (Page tab), using your print plan.
Result: 7
7: February starts on page 5 and takes 2 pages, so March's First page number is 7.
How do I get "of 10" for the whole pack?
&[Pages] counts the pages of the sheet being printed, not the whole workbook. The safe fix is to type the total as plain text in each footer: Page &[Page] of 10. Microsoft's Mac instructions also show adding +2 after &[Pages] to adjust the total, but typing the number works everywhere.
Result: Page &[Page] of 10
Page &[Page] of 10: the exact text to type into each sheet's footer.
First page, odd and even pages, order, and removing numbers
Click in a header or footer box and look at Options on the Header & Footer tab. Different First Page leaves page 1 (a cover) without the header and footer. Different Odd & Even Pages lets you put numbers on the outside edge for double-sided printing: right footer on odd pages, left on even.
On a sheet that's both wide and long, Excel numbers pages down first, then across. To number across first, use Page Setup > Sheet tab > Page order > Over, then down. To remove page numbers, open Page Setup > Header/Footer and choose (none) in the Header or Footer list (it's at the top of the list). If the numbers come out on more pages than you expected, fix the page breaks first: see print an Excel sheet on one page.
Common mistakes
Typing page numbers into cells
They won't follow page breaks. Use Insert > Header & Footer so Excel numbers the printed pages.
Looking for the numbers in Normal view
They only appear in Page Layout view, Print Preview and on paper.
Expecting &[Pages] to count every sheet
It counts the printed sheet's pages. Type the workbook total as text and set First page number per sheet.
Leaving sheets grouped after adding footers
Right-click a tab > Ungroup Sheets, or your next edit lands on every sheet.
FAQ
How do I insert page numbers in Excel?
Insert > Header & Footer, click a header or footer box, then click Page Number on the Header & Footer tab. Click a cell to see the result in Page Layout view.
How do I add "Page 1 of 2" in Excel?
In the footer box, type Page, click Page Number, type " of ", then click Number of Pages. The code reads Page &[Page] of &[Pages].
Why can't I see page numbers in Excel?
You're in Normal view. Switch to View > Page Layout or open Print Preview with Ctrl+P.
How do I start page numbering at 2 in Excel?
Page Layout > Page Setup dialog launcher > Page tab, type 2 in First page number and click OK. Type Auto to reset it.
Can I put page numbers in a cell?
Not reliably: no worksheet function returns the printed page number. Keep them in the header or footer.
Functions used
Related guides
- How to add a header in Excel
- How to print an Excel sheet on one page
- Excel print titles not working: how to repeat the header row on every page
- Excel print area not working: why it prints the wrong cells and how to fix it
- How to remove the dotted page break lines in Excel
- How to abbreviate large numbers in Excel: thousands (K), millions (M), billions (B)
Updated