Startseite » Excel EN » Header and Footer in Excel: How to Add and Format Them with Ease

Header and Footer in Excel: How to Add and Format Them with Ease

To insert a header and footer in Excel, go to the Insert tab → click Text group → choose Header & Footer. 📝 This lets you display details like page numbers, dates, file names, or custom titles at the top (header) or bottom (footer) of each printed page. Whether you’re preparing invoices, reports, or data sheets, headers and footers make your work look professional and organized. They’re supported on Windows, macOS, and Ubuntu Excel alternatives like LibreOffice Calc.

🧠 Why Use Header and Footer in Excel?

Headers and footers appear on printed pages only, not on the working spreadsheet. Use them to:

  • Add page numbers 📄
  • Include file names or sheet names
  • Show dates and timestamps
  • Insert company name or author info
  • Maintain consistent formatting in multi-page documents

Perfect for financial reports, school projects, or company templates!

➕ How to Add a Header or Footer in Excel

Steps (Windows/macOS Excel):

  1. Go to the Insert tab
  2. Click Text > Header & Footer
  3. Excel switches to Page Layout View
  4. Click into the header or footer area to type your content
  5. Use the Header & Footer Tools to insert elements like page numbers, date, file path, etc.

Keyboard Shortcut (Windows):

  • Alt + N + H to insert a header
  • Alt + N + F to insert a footer

macOS Shortcut (Ribbon Navigation):

  • Use Fn + Alt/Option to access Insert > Header & Footer (no direct shortcut)

✅ The header/footer will apply across all pages when printing or exporting as PDF.

✏️ What Can You Add to Headers and Footers?

Using the Header & Footer Tools Design tab, you can insert:

ElementButton
Page number&[Page]
Total pages&[Pages]
Current date&[Date]
Current time&[Time]
File name&[File]
Sheet name&[Tab]
Custom textType directly into box

📌 Combine multiple elements like:

Page &[Page] of &[Pages] | Generated: &[Date] | File: &[File]

🎨 Formatting Headers and Footers

You can:

  • Use Left, Center, Right sections
  • Format text: font, size, bold, italics
  • Add logos (Windows only): Header & Footer Tools > Picture
  • Use Insert > Symbol to add special characters

💡 Tip: Use Page Layout View to preview formatting in real time.

🗑️ How to Remove a Header or Footer

Steps:

  1. Go to Insert > Header & Footer
  2. Click into the header/footer
  3. Delete all content manually
  4. Or use Page Setup > Header/Footer > None

✅ Now your worksheet prints without any headers or footers.

🖨️ Print Settings & Headers/Footers

To control header/footer visibility in print:

  1. Go to File > Print or press Ctrl + P
  2. Click Page Setup
  3. Use the Header/Footer tab to customize
  4. Preview using Print Preview

🔍 You can also set different headers/footers for the first page and odd/even pages.

🐧 Adding Headers and Footers in Ubuntu (LibreOffice Calc)

LibreOffice Calc offers header/footer tools via the print setup:

Steps:

  1. Go to Format > Page Style
  2. Navigate to the Header or Footer tab
  3. Check “Header on” or “Footer on”
  4. Click Edit to customize content and formatting
  5. Use formatting buttons for page number, date, sheet name, etc.

Ubuntu Shortcuts:

  • Ctrl + P → Open Print Preview
  • Use menus: Format > Page Style > Header/Footer

🧩 Headers and footers will apply only during printing or exporting to PDF.

📊 Real-World Use Cases

Document TypeHeader/Footer Use
InvoicesCompany name, invoice #, page numbers
Financial reportsSheet title, confidentiality notice
Academic papersName, date, page numbers
Meeting agendasDocument title, date/time
Multi-page exportsPage X of Y, file name

⚠️ Common Mistakes to Avoid

  • ❌ Expecting headers/footers to appear in Normal view (they’re print-only)
  • ❌ Forgetting to switch from Page Layout View
  • ❌ Using inconsistent formatting across sheets
  • ❌ Overloading header/footer with too much info
  • ❌ Forgetting to preview before printing—text might be cut off

✅ Pro Tip: Always preview your document (Ctrl + P) before sending or printing!

FAQs

How do I add a header or footer in Excel?
Go to Insert > Header & Footer, then type your content or use the tools provided.

Can I add different headers to each sheet?
Yes, but each sheet must be customized individually.

Why can’t I see my header or footer in normal view?
Headers and footers are only visible in Page Layout View or Print Preview.

How do I add a page number in the footer?
Use &[Page] in the footer section or click the Page Number button in Header & Footer Tools.

Can I insert images into the header?
Yes, but only in the Windows version of Excel.

Do headers and footers show up when exporting to PDF?
Yes, they appear exactly as they would on a printed page.

✅ Final Thoughts on Header and Footer in Excel

Adding a header and footer in Excel is a simple yet powerful way to make your documents look professional, organized, and print-ready. 📑 Whether you’re delivering a client report or preparing a data sheet, headers and footers add clarity, consistency, and context—without cluttering your spreadsheet.

Once you get the hang of it, you’ll never print another spreadsheet without a polished header/footer again! 🎯

Complete List of Windows Keyboard Shortcuts

If you need help for Windows, you can find a whole list of all keyboard shortcuts here.

https://keyboard-shortcuts.org/

Advertisment