Excel Print Page Number

What this does

Page numbers live in the header or footer, not in a cell, and Excel inserts them as the field code &[Page] so they renumber automatically as the printout grows. The neighbouring Number of Pages button adds &[Pages] for a "Page 3 of 12" pattern. Where numbering starts and in what order pages are counted are set separately in Page Setup: First page number on the Page tab, and Down, then over / Over, then down on the Sheet tab. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. Treat “excel print page number” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected page shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a workspace setting that makes a big sheet comfortable to navigate into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

To print "Page 3 of 12" centred at the bottom: Insert ▸ Header & Footer ▸ click the centre footer box ▸ type "Page " ▸ press Page Number ▸ type " of " ▸ press Number of Pages. The box shows Page &[Page] of &[Pages]. To make the first printed page count as 4 instead of 1, open Page Layout ▸ the Page Setup dialog launcher ▸ Page tab ▸ First page number: 4. A stapled report without page numbers cannot be referenced in a meeting, and a PDF without them cannot be quoted in an email — it is thirty seconds that makes a printout citable. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.

In Google Sheets

The Insert ▸ Text ▸ Header & Footer steps above are for Excel on Windows desktop. On Mac desktop, use Insert ▸ Header and Footer. Excel for the web cannot insert or edit worksheet headers or footers; open the workbook in desktop Excel. In Google Sheets, use File ▸ Print ▸ Headers & footers ▸ Edit custom fields instead of the Excel ribbon path. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. Here is the takeaway for “excel print page number”: follow the steps at the top, check the result on the sheet itself, and keep undo in mind while you experiment. Done once deliberately, it becomes something you do from memory in Excel rather than something you search for again.

Common mistakes

• Typing the numbers by hand, which stops matching the moment a row is added.
• Numbering each sheet separately and expecting a continuous sequence across a multi-sheet print — select all the sheets before printing so Excel counts them as one job.
• Looking for the numbers in Normal view, where headers and footers are never shown.
• Leaving Page order on the default when a wide sheet spills sideways, so page 2 is the sheet's right-hand half rather than its continuation downwards.

Frequently asked questions