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
| Step | What to do |
|---|---|
| 1 | Select the worksheet |
| 2 | Insert tab > Text group > Header & Footer |
| 3 | Click the left, center or right section of the header or footer |
| 4 | Header & Footer tab > Header & Footer Elements group > Page Number |
| 5 | Click outside the box, then View > Normal to go back |
Add a page number to one worksheet
- Select the worksheet.
- On the Insert tab, in the Text group, select Header & Footer.
- Excel switches to Page Layout view, and you can also reach that view with the Page Layout button on the status bar.
- Click the left, center or right section of the header or footer.
- On the Header & Footer tab, in the Header & Footer Elements group, select Page Number.
- 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 select | How |
|---|---|
| Adjacent sheets | Click the first tab, hold Shift and click the last tab |
| Nonadjacent sheets | Click the first tab, hold Ctrl and click the others |
| Every sheet | Right-click a sheet tab and choose Select All Sheets |
- On the Page Layout tab, select the dialog box launcher in the Page Setup group.
- On the Header/Footer tab, choose Custom Header or Custom Footer.
- Click the Left, Center or Right section box.
- 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.
| Element | Code or note |
|---|---|
| Page number | &[Page] |
| Total pages | &[Pages] |
| Date | &[Date] |
| Time | &[Time] |
| File name, file path, sheet name | Available 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
- On the Page Layout tab, open the Page Setup dialog box launcher.
- On the Page tab, type a number in the First page number box.
- 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.
| Option | What it does |
|---|---|
| Different First Page | Removes the header and footer from the first printed page |
| Different Odd & Even Pages | Lets odd and even pages have their own headers and footers |
| Scale with Document | Ties header and footer size to the worksheet scaling |
| Align with Page Margins | Lines the header and footer edges up with the worksheet margins |
Change the font or size of a header
- Click the Page Layout View button on the status bar.
- Select the header or footer text you want to change.
- On the Home tab, use the Font group to change the font, style or size.
- 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.
Related print settings
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.