Headers in Excel sit above your worksheet content when you print or view the file in Page Layout mode. They are not visible in the standard Normal view, which is why so many people get confused the first time they try to add one. You set up a header once, and it repeats on every printed page of the worksheet. That is huge for reports, invoices, audit trails, and anything you hand to a manager who needs to know what they are looking at.
The header area in Excel is split into three sections: left, center, and right. You can drop text, page numbers, dates, file paths, sheet names, or even an image in any of those boxes. Most folks just type a title in the center box and call it done. Power users build multi-line headers with the company name on top, the report date in the middle, and the page count on the right. Whatever you need, the tools are there once you know where to look.
This guide walks through every method, every shortcut, and every gotcha. Whether you are running Excel 365, Excel 2021, Excel 2019, or even Excel 2016, the steps are nearly identical. We will also cover the Excel for Mac differences, header behavior across multiple sheets, and the most common mistake people make when a header disappears on the second page. Quick note: if you are looking for footers, the process is identical, just swap header for footer wherever you see it. Excel treats them as twins.
This is the route most people learn first, and it is the cleanest for one-off headers. Open the workbook, click the Insert tab on the ribbon, and look for the Text group on the right side. Click Header & Footer. Excel will switch the worksheet into Page Layout view automatically and drop your cursor into the center header box.
Now just type. Whatever you key in shows up centered at the top of every printed page. Want it on the left? Click the left box first, then type. Same for the right. You can also use the Header & Footer Tools contextual tab that appears at the top of the ribbon when your cursor is inside a header box. That tab gives you one-click buttons for page number, page count, current date, current time, file path, file name, sheet name, and picture.
When you are done editing, click anywhere in the worksheet cells below the header area. To return to Normal view, head to the View tab and click Normal. Your header is saved with the workbook and will print whenever you hit Ctrl+P. No extra steps required, and no separate save command for the header itself - it travels with the file from this point forward.
Press Alt + N + H in sequence (not held down) to jump straight to the header in Excel for Windows. It is faster than mousing through the ribbon and works in every version from Excel 2010 forward. On Mac, use the View menu shortcut Command+Option+P to switch to Page Layout, then click the header area directly. Memorize this and you save several seconds every time you format a report - it adds up across hundreds of files.
If you prefer dialog boxes over ribbon clicks, or you need finer control, use the Page Setup dialog. Go to the Page Layout tab and click the tiny arrow in the bottom-right corner of the Page Setup group. The dialog opens. Click the Header/Footer tab.
You will see a dropdown labeled Header with built-in options like Page 1 of ?, Confidential, and combinations of file name plus date. Pick one, and Excel inserts it. For something custom, click Custom Header. A second dialog opens with three text boxes labeled Left section, Center section, and Right section. Type your text in whichever boxes you need. The toolbar at the top of that dialog has icons for inserting dynamic fields - page number, total pages, date, time, path, file, sheet, picture, and format picture.
The Page Setup route is the only way to apply a header to multiple sheets at once. Select your sheets first by Ctrl-clicking the sheet tabs (or right-click a tab and pick Select All Sheets). Then open Page Setup and configure the header. It pushes to every selected sheet in one go. Unselect when you are done so you do not accidentally edit other tabs.
Best for company name, logo, or department. Aligns flush left at the top margin of every page.
Default landing spot. Most reports put the title here. Bold and 12pt by default.
Page numbers, dates, or version codes typically live here. Aligns flush right.
Page numbers, file paths, and dates update automatically every time you open or print the file.
Static text is fine, but Excel really shines when you use dynamic fields. These are placeholders that pull live data when the file prints. For example, instead of typing Page 1 and watching it stay Page 1 forever, you insert the page-number field and Excel renders it correctly on every page.
Inside the header editor, click the spot where you want the field. Then either use the Header & Footer Tools ribbon (Design tab) or the toolbar icons in the Custom Header dialog. The most common fields you will use are:
You can mix and match. A typical professional header might read Quarterly Report - &[Date] in the center and Page &[Page] of &[Pages] on the right. Excel handles all the rendering at print time, so you never have to update anything manually. The fields stay accurate even if you copy the worksheet to a new file.
Use the Insert tab > Text group > Header & Footer. Or use Page Layout tab > Page Setup launcher > Header/Footer tab. Keyboard shortcut: Alt + N + H. Works identically in Excel 2016, 2019, 2021, and Microsoft 365.
Go to Insert menu > Header & Footer (Excel for Mac 2019+). Or use View menu > Page Layout, then click the header area directly. The contextual Header & Footer ribbon appears at the top. Functions are identical to Windows but the layout is slightly different.
Open the file in Excel for the web. Click Insert > Header & Footer. The browser version supports text, page numbers, dates, file name, and sheet name. Images in headers are not supported in Excel Online - you need the desktop app for that.
Excel mobile apps (iOS, Android) have limited header editing. You can view existing headers but cannot edit them in most cases. For full header control, use the desktop app or Excel Online from a browser.
Pictures in headers are perfect for branded reports - company logo top left, page numbers top right, sharp and consistent. To insert an image, click into the header section you want, then look for the Picture button on the Header & Footer Tools Design ribbon. In the Custom Header dialog, the picture icon looks like a small landscape image.
Excel opens a file picker. Browse to your logo (PNG and JPG work best, GIF and BMP are also supported). Select it and click Insert. The header now shows the placeholder code &[Picture] - that is normal. Click anywhere else and the actual image renders. To adjust the size, click back into the header section, then click the Format Picture button on the Design ribbon. A dialog lets you resize by percent or by exact dimensions in inches.
One important note: Excel embeds the image into the workbook by default, so the file size grows. If your logo is a high-resolution PNG, consider compressing it before inserting. A 500KB logo can balloon a workbook unnecessarily. Use a 100-200KB version sized to roughly the dimensions you actually need in the header.
Reports often need a special header on the first page - maybe a cover page with a big title - and then a simpler header on every following page. Excel handles this through two checkboxes in the Page Setup dialog. Open Page Setup from the Page Layout tab, click the Header/Footer tab, and look at the bottom of the dialog.
Check Different first page. Now the Custom Header dialog gives you two tabs: Header and First Page Header. Configure them independently. The first page header only renders on page 1 of the printed output; the regular header takes over for pages 2 and beyond.
The other checkbox, Different odd & even pages, splits headers between odd-numbered pages (1, 3, 5, 7...) and even-numbered pages (2, 4, 6, 8...). This is useful for double-sided print jobs where you want page numbers on the outer edge of each spread. Odd pages get the page number on the right, even pages get it on the left, and the report looks like a properly bound document.
Both checkboxes can be active at the same time. That gives you three header configurations: first page, odd pages, even pages. Most reports do not need that level of control, but it is there when you do. Designers and accountants who print bound monthly statements lean on this feature heavily.
Adding a header is easy. Getting rid of one trips up surprising number of people because Excel hides the header content in Normal view. Here is the cleanest removal method: switch to Page Layout view by clicking View tab > Page Layout. Now you can see the header area at the top of each page. Click into the section that has text, select the content, and press Delete. Repeat for all three sections if needed. Return to Normal view, save the file, and the header is gone.
To edit, do the same thing - switch to Page Layout, click into the header section, and start typing. Excel auto-saves your changes when you click outside the header area. There is no separate Save header command; it just happens silently.
If you want to wipe headers from multiple sheets at once, the Page Setup dialog is faster. Select the sheets (Ctrl-click tabs), open Page Setup, go to the Header/Footer tab, and pick (none) from the Header dropdown. Click OK. All selected sheets lose their headers in one action. This is also the safest method when you inherit a workbook from someone else and you are not sure which sheets carry custom headers.
Two issues come up over and over again. First: I typed a header but I do not see it. Almost always, the user is in Normal view, which deliberately hides headers and footers. Switch to Page Layout view (View tab > Page Layout) or open Print Preview (Ctrl+F2) to see the header. Normal view is for cell editing, not page composition.
Second: My header shows on page 1 but disappears on page 2. This happens when the Different first page option is checked but only the first page header was filled in. Open Page Setup, go to Header/Footer, click Custom Header, and check the regular Header tab as well as the First Page Header tab. Fill in both, or uncheck the Different first page box to use one header throughout.
A third subtle issue: header text appears tiny in print. Excel uses a default 11pt font for headers, which can look small on letter-size paper. Inside the Custom Header dialog, select the text and click the Format Text button (looks like an A). Change font size to 14 or 16 for better readability. You can also bold, italicize, or change color from that same dialog.
If you do a lot of report formatting, learning Excel's header field codes saves time. Instead of clicking through ribbon buttons, you can type the codes directly into the Custom Header dialog. Here are the essentials:
Once you know the codes, building complex headers becomes a matter of typing one line. For example, &B&14Quarterly Sales Report&B - &[Date] renders as bold 14pt Quarterly Sales Report followed by the print date in default size and weight. The &B toggles bold on at the start and off after Report.
That covers every angle of inserting headers in Excel. Whether you stick with the ribbon, master the Page Setup dialog, or memorize field codes for power-user efficiency, you now have the full toolkit. Headers might seem like a small detail, but in professional reporting they make the difference between a worksheet that looks finished and one that looks rushed. Take five minutes to set them up properly on every report you produce, and your printed output will always look polished.
If you want to test what you have learned, the practice questions linked above run through the most common interview-style and exam-style scenarios on Excel headers, footers, and page setup. Many Excel certification exams (MOS, MO-200, MO-201) specifically test header skills, and the same questions come up in entry-level data analyst interviews when someone asks you to format a report for printing. Spend twenty minutes on the practice test and you will breeze through any Excel header question that comes your way - in an exam, an interview, or just a Monday morning report request from your boss.
If you build the same header format every month - same logo, same date field, same page numbering style - save the file as an Excel template (.xltx). Next month, open the template, populate the data, and the header is already perfect. Templates live in your Documents/Custom Office Templates folder by default and appear in the File > New screen for quick access.
Headers earn their keep in real reporting workflows. Accounting teams put the fiscal period in the center header so every printed page of a general ledger export shows the reporting month. Sales teams add region or rep name to the left header when distributing pipeline reports to managers.
Auditors stamp the audit date and report version on every page so paper trails stay defensible months later. HR teams add confidentiality notices in headers when printing salary spreadsheets. Construction project managers add the project code and phase to keep stacks of estimates from getting mixed up on a busy desk.
None of these require special skills - just one well-built header that lives with the workbook from the first day to the final archive copy. Once you set the pattern, your printed reports always look organized, branded, and ready to hand off without a second pass through formatting.