Subscribe

Lesson 84 of 104 3 min Updated Completed

How to Add a Header and Footer

A header prints at the top of every page, and a footer at the bottom. They’re great for titles, dates and page numbers.

  1. Click View > Page Layout.

    The Page Layout button on the View tab

  2. Click Add header at the top of the page. Then, on the Header & Footer tab, click Current Date.

    Adding the current date from the Header & Footer tab

    Excel adds a date code, &[Date], which updates to the current date each time you print. The header has left, center and right sections; click any of them to add text there.

  3. Click anywhere in the sheet to see the header.

    The date shown in the header

  4. To use a different header on the first page, or on odd and even pages, tick Different First Page or Different Odd & Even Pages on the Header & Footer tab.

    The Different First Page option

  5. To go back to the normal view, click View > Normal.

    The Normal button on the View tab

  6. To check your headers and footers, click File > Print.

    The header shown in the print preview

Note: In older versions of Excel, the Header & Footer tab is called Design.

Next: add page numbers to the footer.