How To Add Page Numbers And Headers In Excel (2026)

Excel does not number your printed pages by default, so a long worksheet comes out as a stack of pages with nothing on them to tell you the order.

You add numbers, a title, a date or a file name through a header or footer, and Microsoft’s steps are the same for the desktop app.

Here is how to add page numbers to one sheet or many, start the count at a different number, and remove headers and footers again.

Quick answer: add a page number

StepWhat to do
1Select the worksheet
2Insert tab > Text group > Header & Footer
3Click the left, center or right section of the header or footer
4Header & Footer tab > Header & Footer Elements group > Page Number
5Click outside the box, then View > Normal to go back

Add a page number to one worksheet

  1. Select the worksheet.
  2. On the Insert tab, in the Text group, select Header & Footer.
  3. Excel switches to Page Layout view, and you can also reach that view with the Page Layout button on the status bar.
  4. Click the left, center or right section of the header or footer.
  5. On the Header & Footer tab, in the Header & Footer Elements group, select Page Number.
  6. Click outside the header or footer to see the real number.

Excel inserts the code &[Page] into the box, and it turns into the actual page number when you click away.

Show Page 1 of 5 instead of just 1

To show the total page count as well, click after the &[Page] code and type a space, the word “of” and another space.

Then select Number of Pages in the Header & Footer Elements group.

The result is &[Page] of &[Pages], which prints as a number followed by the total.

Why the numbers do not show in Normal view

Page numbers added through a header or footer appear only in Page Layout view and on the printed page.

Go to View > Workbook Views > Normal, or select the Normal button on the status bar, when you want to return to regular editing.

Add page numbers to several sheets at once

Select the sheets first, and the word Group appears in the title bar when more than one is selected.

Sheets to selectHow
Adjacent sheetsClick the first tab, hold Shift and click the last tab
Nonadjacent sheetsClick the first tab, hold Ctrl and click the others
Every sheetRight-click a sheet tab and choose Select All Sheets
  1. On the Page Layout tab, select the dialog box launcher in the Page Setup group.
  2. On the Header/Footer tab, choose Custom Header or Custom Footer.
  3. Click the Left, Center or Right section box.
  4. Select Insert Page Number, which adds &[Page].

When you finish, click a sheet tab that is not selected, or right-click a selected tab and choose Ungroup Sheets, so later edits do not hit every sheet.

Use a built-in header or footer

Select a header or footer box in Page Layout view, and the Header and Footer Tools appear with a Design tab.

In the Header & Footer group, choose Header or Footer and pick one of the presets from the list.

Add the date, time or file name

The same Header & Footer Elements group inserts other details as placeholder codes.

ElementCode or note
Page number&[Page]
Total pages&[Pages]
Date&[Date]
Time&[Time]
File name, file path, sheet nameAvailable as buttons in the same group

To remove a date or time, select its code in the box and press Delete.

Start numbering at a different number

  1. On the Page Layout tab, open the Page Setup dialog box launcher.
  2. On the Page tab, type a number in the First page number box.
  3. Select OK.

This lets numbering carry on across sheets, so if the first sheet prints on two pages you would set the second sheet to start at 3.

Type Auto in the box to go back to the default numbering.

Change the page order for wide sheets

A sheet that is both long and wide can be numbered in two directions.

On the Page Layout tab, open the Page Setup dialog box launcher, select the Sheet tab, and choose Down, then over or Over, then down under Page order.

The preview box in the dialog shows the direction you picked.

Header and footer options

These checkboxes sit on the Design tab in the Options group, and the Page Setup dialog has the same options.

OptionWhat it does
Different First PageRemoves the header and footer from the first printed page
Different Odd & Even PagesLets odd and even pages have their own headers and footers
Scale with DocumentTies header and footer size to the worksheet scaling
Align with Page MarginsLines the header and footer edges up with the worksheet margins

Change the font or size of a header

  1. Click the Page Layout View button on the status bar.
  2. Select the header or footer text you want to change.
  3. On the Home tab, use the Font group to change the font, style or size.
  4. Select the Normal button on the status bar to go back.

If you leave Scale with Document checked, the text scales with the worksheet, and your font settings may not show accurately in print preview.

Type your own text, line breaks and ampersands

You can type any text into a header or footer box, and pressing Enter inside a box starts a new line.

To show a single ampersand, type two of them, so “Subcontractors && Services” prints with one.

Remove page numbers, headers and footers

For one sheet, go to Insert > Header & Footer, click the box and press Delete or Backspace.

For several sheets, select them, open the Page Setup dialog, and on the Header/Footer tab choose (none) in the Header or Footer box, scrolling to the top of the list if you need to.

Chart sheets use the Page Setup dialog

Microsoft says chart sheets can only be numbered through the Page Setup dialog.

Use the Custom Header or Custom Footer buttons on its Header/Footer tab, the same way as for worksheets.

If the numbers look right but the pages break in the wrong place, see our guide to fitting an Excel sheet on one page.

To keep your column labels at the top of each page, use our steps for repeating header rows on every printed page.

You can also limit what prints with a print area, and Word users can read about starting page numbers on a later page in Word.

Sources

Steps come from Microsoft’s pages Insert page numbers on worksheets and Headers and footers in a worksheet.

The date and time codes come from Microsoft’s page on inserting the date or time into a header or footer.

Leave a Reply

Your email address will not be published. Required fields are marked *