Cellwise Start free

Excel guide · 5 min read

How to add page numbers in Excel

Quick answerGo to Insert > Header & Footer, click the left, center or right box of the header or footer, then click Page Number on the Header & Footer tab. For "Page 1 of 3", type Page before &[Page], then " of " after it, and click Number of Pages. Click any cell to see the numbers. They only show in Page Layout view, Print Preview and on paper, never in Normal view.

Sample data

Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.

RowABCD
1SheetPagesFirst page numberFooter to type
2Summary11Page &[Page] of 10
3January32Page &[Page] of 10
4February25Page &[Page] of 10
5March47Page &[Page] of 10
6
7Total pages10

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.

  1. Click the sheet you want to number.
  2. Go to Insert > Header & Footer. Excel switches to Page Layout view.
  3. Scroll to the bottom of the page and click the left, center or right footer box (the center one says Add footer).
  4. Type Page and a space, then click Page Number on the Header & Footer tab. The box shows Page &[Page].
  5. Type a space, the word of, and a space, then click Number of Pages. The box now reads Page &[Page] of &[Pages].
  6. Click any cell on the sheet. The codes turn into real numbers: Page 1 of 3, Page 2 of 3, and so on.
  7. 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.

  1. Page Layout > Page Setup dialog launcher (the small arrow in the corner of the Page Setup group).
  2. On the Page tab, type 3 in First page number.
  3. 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.

  1. To add the same footer to every sheet at once, right-click a tab > Select All Sheets.
  2. Page Layout > Page Setup dialog launcher > Header/Footer tab > Custom Footer, and build the footer with the Insert Page Number button.
  3. Right-click a tab > Ungroup Sheets. Then set First page number on each sheet separately (Page tab), using your print plan.
=C4+B4

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.

="Page &[Page] of "&SUM(B2:B5)

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

Updated