How to Add Header and Footer in Excel - Practical Guide

Learn to add headers and footers to your Excel spreadsheets for professional printing. This tutorial covers inserting page numbers, dates, file names, and custom text in header and footer sections. Headers and footers automatically appear on every printed page, ensuring consistent branding and document identification across multi-page reports.

Why This Matters

Headers and footers enhance document professionalism and provide essential information like page numbers, dates, and company branding on printed sheets. This skill is critical for creating polished reports and ensuring compliance with corporate document standards.

Prerequisites

•Basic Excel spreadsheet with data to print
•Understanding of Print Preview and Page Setup options

Step-by-Step Instructions

Open the Insert Menu

Click the Insert tab on the ribbon, then locate the Header & Footer section on the far right of the toolbar.

Click Header & Footer Button

Select Insert > Header & Footer to open the Header & Footer dialog box and enter Design mode for customization.

Add Header Text

Click in the Left Header, Center Header, or Right Header section and type your text, or use the Insert Page Number, Insert Date, or Insert File Name buttons to add dynamic fields.

Add Footer Text

Click in the Left Footer, Center Footer, or Right Footer section and add text or use Insert buttons for page numbers, dates, and file names as needed.

Apply and Preview

Click OK to close the dialog, then go to File > Print Preview to verify headers and footers appear correctly on all pages before printing.

Alternative Methods

Using Page Layout Tab

In Excel 2010 and later, click Page Layout > Page Setup dialog launcher, then navigate to the Header/Footer tab for the same options in a different interface.

Page Setup Dialog Method

Access File > Print > Print Settings > Page Setup to configure headers and footers directly from the print preview screen.

Tips & Tricks

✓Use &[Page] for page numbers, &[Pages] for total pages, and &[Date] for current date—these fields update automatically.
✓Place page numbers in the footer for easier reference and less visual clutter than headers.
✓Center the file name in the header and page numbers in the footer for a balanced, professional appearance.

Pro Tips

★Use ampersand codes like &[Tab] to insert the sheet name and &[File] for the full file path automatically.
★Set different headers and footers for odd and even pages using Page Setup > Different odd and even pages checkbox for two-sided printing.
★Add font formatting to headers and footers by selecting text and using the font dropdown in the Header & Footer dialog.

Troubleshooting

Headers and footers not showing in Print Preview

Switch to Page Layout view or Print Preview mode from File > Print. Headers and footers only appear in these views, not in Normal editing view.

Header or footer text is cut off or overlapping content

Increase top or bottom margins via Page Setup > Margins tab, or reduce header/footer text length and font size.

Dynamic fields like &[Page] are printing as literal text

Ensure codes are entered correctly without extra spaces; use exact syntax &[Page], &[Date], &[File], &[Tab], or &[Time].

Different headers/footers on first page not working

Open Page Setup > Header/Footer tab, check the 'Different first page' checkbox before editing.

Frequently Asked Questions

Can I have different headers on different sheets in the same workbook?

Yes, headers and footers are applied per sheet. Select each sheet tab individually and repeat the Header & Footer steps for unique headers on each sheet.

How do I add a company logo to the header?

Click the Insert Picture button in the Header & Footer dialog (Insert tab) to embed an image. The logo will appear in every printed header.

Can I remove headers and footers once added?

Yes, go to Insert > Header & Footer, clear the text from all header and footer sections, and click OK to remove them completely.

Why are margins affecting my header and footer spacing?

Headers and footers are positioned relative to page margins. Adjust margins via Page Setup > Margins to control spacing between content and headers/footers.