Excel guide · 6 min read
How to add a header in Excel
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Report title | Type this in the header | Button | Code it inserts | |
| 2 | R&D budget FY2027 | R&&D budget FY2027 | Page Number | &[Page] | |
| 3 | Profit & Loss, Q3 2026 | Profit && Loss, Q3 2026 | Number of Pages | &[Pages] | |
| 4 | Sales by region, Q3 2026 | Sales by region, Q3 2026 | Current Date | &[Date] | |
| 5 | Health & Safety checklist | Health && Safety checklist | Current Time | &[Time] | |
| 6 | File Path | &[Path]&[File] | |||
| 7 | File Name | &[File] | |||
| 8 | Sheet Name | &[Tab] | |||
| 9 | Picture | &[Picture] |
Download this sheet as an Excel practice file (.xlsx)
Header or header row? Two different things
People mean two things by "add a header in Excel", so check which one you need:
- A page header is text in the top margin of every printed page: a report title, the date, a company name or logo. That's this guide.
- A header row is the row of column names at the top of your data (Item, Date, Amount). To make Excel treat row 1 as headers, select the data and use Insert > Table and tick My table has headers. To keep it visible while you scroll, use View > Freeze Panes > Freeze Top Row (freeze panes). To print it on every page, use Page Layout > Print Titles (print titles not working).
Add your own header text
The header has three boxes: left, center and right. A common layout is the report title in the center, the company name on the left and the date on the right. Press Enter inside a box to start a second line.
- Click the sheet you want a header on. Headers are set per sheet.
- Go to Insert > Header & Footer. Excel switches to Page Layout view with the header area at the top of the page.
- Click the center header box and type your text, for example Sales by region, Q3 2026.
- Click the left or right box to add more.
- Click any cell to close the header and keep it, or press Esc to close it without keeping your changes.
- Go back with View > Normal (or the Normal button on the status bar).
The ampersand trap: R&D prints as RD
In a header, & starts a code (like &[Page]), so a single ampersand in your text goes missing or turns into something odd. Microsoft's fix is to type two: Health && Safety prints as Health & Safety. If your report titles live in cells, a formula can do the doubling for you, and you paste the result into the header box.
Result: R&&D budget FY2027
R&&D budget FY2027: type or paste this, and the header prints R&D budget FY2027.
Can I build a whole header line with a formula?
Yes, as text to paste. Codes like &[Date] are just typed text in the header box, so they can be part of the string.
Result: Health && Safety checklist - printed &[Date]
Health && Safety checklist - printed &[Date], which prints as "Health & Safety checklist - printed" followed by the date.
Can a header show the value of a cell?
Not directly. A header doesn't hold formulas or cell references, so it won't update when a cell changes. Paste the text in, or put the title in row 1 of the sheet and repeat it with Print Titles.
Add the date, file name, sheet name or file path
While the cursor is in a header box, Excel shows the Header & Footer tab (older versions call it Design). Its Header & Footer Elements group has buttons that insert codes, listed in columns D and E of the sample. The codes become real values on the printout, so the date is always the day you print and the file name follows any rename.
Sheet Name (&[Tab]) is handy on workbooks with a sheet per month or region: copy one sheet and every copy prints its own name. File Path helps the next person find the original. For a ready-made header, use the Header drop-down on the left of the same tab. Page numbers work the same way and have their own guide: add page numbers in Excel.
- Click inside the left, center or right header box.
- On the Header & Footer tab, click Current Date, File Name, Sheet Name or another element.
- Type any words around the code, for example Printed &[Date].
- Click a cell to see the real values.
Add a logo to the header
A logo goes in a header box as a picture. The box shows &[Picture] instead of the image until you click out of it. A big picture pushes into your data or onto a second line, so resize it and make room for it.
- Click the left header box, then Picture on the Header & Footer tab, and choose the image file.
- With the cursor still in the box, click Format Picture and set the height on the Size tab (around 1.5 cm or half an inch works for most logos).
- If the logo overlaps the data, open Page Layout > Margins > Custom Margins and increase Top. The Header box on the same tab sets how far the header sits from the top edge of the paper; keep it smaller than Top.
- Check the result with Ctrl+P.
First page, odd and even pages, and removing a header
Click a header box and look at Options on the Header & Footer tab. Different First Page removes the header from page 1, which suits a cover page. Different Odd & Even Pages lets you put the date on the right of odd pages and the left of even pages for double-sided printing. Scale with Document makes the header shrink with the sheet when you fit it to one page; clear it to keep the header text the same size on every printout.
To add the same header to several sheets, select their tabs with Ctrl+click, then use Page Layout > Page Setup dialog launcher > Header/Footer > Custom Header. Ungroup afterwards (right-click a tab > Ungroup Sheets). Chart sheets get headers the same way. To remove a header, delete the text in each box, or choose (none) in the Header list on the Header/Footer tab.
Common mistakes
Looking for the header in Normal view
Headers only show in Page Layout view, Print Preview and on paper. Use the Page Layout button on the status bar or Ctrl+P.
Typing the report title into row 1 and calling it a header
It only prints on page 1. Put it in the page header, or repeat row 1 with Page Layout > Print Titles.
Single ampersands in the text
Type && for each &, or use =SUBSTITUTE(A2,"&","&&") and paste the result.
A logo that covers the first rows
Resize it with Format Picture and raise the Top margin above the Header distance.
FAQ
How do I put a header on every page in Excel?
Insert > Header & Footer and type in a header box. A page header prints on every page of that sheet automatically.
Why can't I see my header in Excel?
You're in Normal view. Headers appear only in Page Layout view, Print Preview and on printed pages.
How do I make the first row a header in Excel?
Select the data and choose Insert > Table with My table has headers ticked. To keep it on screen use View > Freeze Panes > Freeze Top Row, and to print it on every page use Page Layout > Print Titles.
How do I add a different header on the first page?
Click a header box, then tick Different First Page under Options on the Header & Footer tab. Page 1 gets its own header boxes, which you can leave empty.
How do I remove a header in Excel?
Insert > Header & Footer, click each box and delete its text, or open Page Layout > Page Setup > Header/Footer and choose (none) in the Header list.
Functions used
Related guides
- How to add a watermark in Excel
- How to add page numbers in Excel
- Excel print titles not working: how to repeat the header row on every page
- How to print an Excel sheet on one page
- Excel print area not working: why it prints the wrong cells and how to fix it
- How to add bullet points in Excel
Updated