In Excel: go to Insert ▸ Text ▸ Header & Footer — Excel switches to Page Layout view with three click-to-type boxes at the top and bottom of the page.
Choose Insert ▸ Text ▸ Header & Footer, or click View ▸ Page Layout and then the header area directly.
Click the left, centre or right box and type your text.
Use the Header & Footer tab buttons for Page Number, Number of Pages, Current Date, File Path, File Name or Sheet Name rather than typing them by hand.
Switch between header and footer with the Go to Header / Go to Footer buttons on that tab.
Tick Different First Page or Different Odd & Even Pages on the same tab when a cover page or a bound document needs it.
Click any cell and return to View ▸ Normal when you are done; use File ▸ Print to check the result.
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. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “inserting a footer in excel”. Start on a copy or a tiny sample, keep the affected footer visible, and compare the result with the tool above before you touch the real workbook. 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. The point is a workspace setting that makes a big sheet comfortable to navigate, but the practical win is that someone else can open the file and understand what happened without asking you.
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. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.
In Google Sheets
If you are in Google Sheets rather than Excel, the good news is that the formula shown here is identical and the workflow barely changes — menus sit across the top instead of in a ribbon, and a few function names differ slightly, but anything you build here moves across with little or no rework. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. The short version of “inserting a footer in excel”: the answer is at the top of this page, the tool proves it on your own numbers, and the sections above explain why it holds so the next variation does not stump you. Excel rewards people who reference cells instead of typing values and who keep inputs separate from formulas, because that is what makes a result you can audit months later. Build it once, deliberately, with the live tool as a check, and you convert a one-off lookup into a reusable skill — which is the whole point of learning the why and not just the what.
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
How do I add a header in Excel?
Insert ▸ Text ▸ Header & Footer. Excel switches to Page Layout view and gives you three boxes at the top of the page — click one and type.
Why can I not see my header?
Headers and footers only render in Page Layout view and in print previews, never in Normal view. Use View ▸ Page Layout to see them on screen.
How do I put the file name in the footer?
Click into the footer box, then press File Name on the Header & Footer tab. It inserts the &[File] code, which stays correct if the workbook is renamed.
How do I repeat my column headings on every printed page?
That is a different feature: Page Layout ▸ Print Titles ▸ Rows to repeat at top, then select the heading row. Headers and footers cannot pull cell content.