How to Make Header in Excel Sticky

What this does

A header or footer is print chrome: text that repeats at the top or bottom of every printed page and is invisible in Normal view. Each has a left, centre and right box, and the Header & Footer tab that appears while you edit supplies buttons for page number, page count, date, time, file path, file name and sheet name — these insert codes such as &[Page] that stay correct as the document grows. This is separate from repeating a *data* header row on each printed page, which is Page Layout ▸ Print Titles ▸ Rows to repeat at top. 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 “make header in excel sticky” 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 header 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

For a report that should show the sheet name on the left and "Page 2 of 7" on the right: Insert ▸ Header & Footer, click the left header box and press the Sheet Name button; click the right footer box, type "Page ", press Page Number, type " of ", press Number of Pages. The footer code reads Page &[Page] of &[Pages] and prints correctly on every page. Anything that leaves the screen as paper or PDF needs to say where it came from and which page you are holding — sheet name, date and "page 3 of 9" are what makes a printout usable. A practical tip: try it on a copy of the sheet or a handful of sample rows first and check the result before you apply it to the real data. That one habit catches almost every surprise while it is still cheap to reverse.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. 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. Treat “make header in excel sticky” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.

Common mistakes

• Expecting the header to show in Normal view — it only appears in Page Layout view and in the print preview.
• Typing "Page 1" literally instead of using the Page Number button, so every page prints as page 1.
• Confusing this with freezing or repeating the top data row; that is Page Layout ▸ Print Titles ▸ Rows to repeat at top.
• Setting the header on one sheet and assuming it applied to the workbook — select all sheet tabs first if you want it everywhere.
• Pasting a large logo into the header without scaling it, which pushes the print area down the page.

Frequently asked questions