How to Insert Headers and Footers in Excel

Whenever I prepare a spreadsheet for printing or sharing as a formal report, headers and footers are one of the first things I set up. They add page numbers, file names, dates, and titles that repeat automatically on every printed page — something that makes a huge difference between a spreadsheet that looks professional and one that looks like a raw data dump. In this article, I’ll show you exactly how I insert, customize, and troubleshoot headers and footers in Excel.

What Headers and Footers Actually Do

A header appears at the top of every printed page, and a footer appears at the bottom. Unlike Freeze Panes (which only affects on-screen scrolling), headers and footers are specifically designed for printed or PDF-exported output. You can insert static text, dynamic fields (like page numbers or today’s date), and even images like a company logo.

Two Ways to Access Headers and Footers

Excel gives me two main paths to set these up, and I use both depending on the situation.

Method 1: Page Layout View (My Preferred Method)

1. Go to the Insert tab.
2. Click Header & Footer in the Text group.

This automatically switches the sheet into Page Layout View, where I can click directly into the header or footer area at the top or bottom of the page and start typing.

Method 2: Page Setup Dialog

1. Go to the Page Layout tab.
2. Click the small arrow in the bottom-right corner of the Page Setup group to open the dialog box.
3. Click the Header/Footer tab.
4. Click Custom Header or Custom Footer to open the editing window.

I use this method when I want more control over left/center/right sections without switching my view mode.

Step-by-Step: Adding a Basic Header

1. Go to Insert > Header & Footer.
2. You’ll see three sections: left, center, and right.
3. Click into the section you want (I usually put the report title in the center).
4. Type your text — for example, “Monthly Sales Report.”
5. Click outside the header box to confirm.

Step-by-Step: Adding Dynamic Fields

This is where headers and footers become genuinely useful. When your cursor is inside a header/footer section, a new Header & Footer Elements group appears on the ribbon (under Design or Header & Footer Tools). You can insert:

• Page Number – inserts &[Page], showing the current page number.
• Number of Pages – inserts &[Pages], showing the total page count.
• Current Date – inserts &[Date], which updates automatically to today’s date.
• Current Time – inserts &[Time].
• File Path – inserts &[Path]&[File], showing where the file is saved.
• File Name – inserts &[File], showing just the file name.
• Sheet Name – inserts &[Tab], showing the worksheet’s name.
• Picture – lets me insert a logo image into the header or footer.

A very common combination I use in the footer is:

Page &[Page] of &[Pages]

This automatically updates as the sheet grows or shrinks, so I never have to manually renumber pages.

Practical Example

Let’s say I’m preparing a quarterly expense report to send to my finance department. Here’s how I’d typically set it up:

• Header (Center): “Quarterly Expense Report — Q1 2026”
• Header (Right): Current Date field, so it automatically shows when the report was generated.
• Footer (Left): File Name field, so anyone printing it knows exactly which file it came from.
• Footer (Right): “Page &[Page] of &[Pages]”

This way, even if someone prints just page 3 out of 10, they can immediately tell what report it is, when it was generated, and where it fits in the full document.

Inserting a Logo or Image in the Header

1. Click into the header section where you want the image.
2. Go to Header & Footer Elements > Picture.
3. Browse and select your image file.
4. Click into the header box and the placeholder &[Picture] will appear.
5. Click outside the box to preview the image.
6. If needed, click back into the header and use Format Picture to resize it.

I use this a lot when preparing branded reports for clients — a small company logo in the top-left header makes a huge difference in professionalism.

Different Headers for First Page, Odd, and Even Pages

Excel lets you customize headers/footers differently depending on the page:

1. Open the Page Setup dialog (Page Layout > small arrow in Page Setup group).
2. Go to the Header/Footer tab.
3. Check Different First Page if you want your first page (like a cover page) to have no header, or a different one.
4. Check Different Odd and Even Pages if you’re printing double-sided and want alternating headers (common for bound reports).

Removing Headers and Footers

To remove header/footer text: click into the section, select the text, and delete it. To completely remove headers and footers from the print layout: go to Page Layout > Print Titles (or Page Setup) > Header/Footer tab, and set both to “(none)” from the dropdown menus.

Common Mistakes I See

• Typing text directly instead of using dynamic fields for page numbers or dates — this means the header becomes outdated or wrong once you add/remove pages.
• Forgetting headers/footers only show up in Page Layout View or Print Preview, not in Normal view — people sometimes think they didn’t work because they can’t see them while typing regular data.
• Adding a header on every sheet manually in a large workbook instead of copying the setup across sheets or applying it once to grouped sheets.
• Oversized logos that push the header area too large, cutting into the printable page space.
• Forgetting to check Print Preview before printing, so header/footer alignment issues go unnoticed until it’s already printed.

Troubleshooting Tips

• If your header text isn’t appearing on the printed page, check File > Print > Print Preview to confirm it’s actually there — Normal view doesn’t always show headers.
• If page numbers show incorrect totals, double-check you used &[Pages] (total pages) not just &[Page] (current page only).
• If a header/footer looks fine on one page but wrong on another, check whether “Different First Page” or “Different Odd and Even Pages” is accidentally enabled.
• If an inserted logo looks stretched, go back into the header, click the image, and adjust its size via Format Picture rather than dragging directly.

Real-World Use Cases

• Finance teams printing multi-page reports with page numbers and generation dates.
• Teachers printing marksheets with school name and class in the header.
• Businesses printing branded invoices or reports with a logo in the header.
• Auditors using file path and file name in footers to trace exactly which version of a document was printed.
• Project managers printing long task lists with “Page X of Y” so recipients know how many pages to expect.

Best Practices I Follow

• Use dynamic fields (Page, Pages, Date, File Name) instead of typing static text wherever the value might change.
• Keep headers concise — a title and maybe a date is usually enough; footers are a better place for file details and page numbers.
• Always check Print Preview before finalizing, especially for multi-page reports.
• If you manage multiple similar reports, set up the header/footer once and save the file as a template so you don’t have to redo it every time.
• Group worksheets (Shift+Click their tabs) before applying the same header/footer setup if you need it consistent across several sheets in one workbook.

Headers and footers might seem like a small formatting detail, but they’re what turns a plain spreadsheet into something that looks and behaves like an actual printed report. Once I started using dynamic fields instead of typing static text, I stopped worrying about outdated page numbers or dates entirely — Excel just keeps them accurate for me.