Microsoft Excel 2016 – Quickly add a built-in Header & Footer

Excel has many built-in headers and footers that you can use. For worksheets, you can work with headers and footers in Page Layout view. Or, you can just choose from the many built-in elements found in the ribbon.

Add a built-in header or footer to a worksheet in Page Layout view:

Click the worksheet to which you want to add a predefined header or footer.

On the Insert tab, in the Text group, click Header & Footer.

Excel displays the worksheet in Page Layout view. You can also click Page Layout View Button image on the status bar to display this view.

Click the left, center, or right header or footer text box at the top or the bottom of the worksheet page.

Tip: Clicking any text box selects the header or footer and displays the Header and Footer Tools, adding the Design tab.

On the Design tab, in the Header & Footer group, click Header or Footer, and then click the predefined

header or footer that you want.

Inserting built-in header and footer elements for a worksheet:

Click the worksheet to which you want to add specific header or footer elements.

On the Insert tab, in the Text group, click Header & Footer.

Excel displays the worksheet in Page Layout view. You can also click Page Layout View Button image on the status bar to display this view.

Click the left, center, or right header or footer text box at the top or the bottom of the worksheet page.

Tip: Clicking any text box selects the header or footer and displays the Header and Footer Tools, adding the Design tab.

On the Design tab, in the Header & Footer Elements group, click the elements that you want.

Closing headers and footers:

To close the header and footer, you must switch from Page Layout view to Normal view.

On the View tab, in the Workbook Views group, click Normal.

You can also click Normal Button image on the status bar.