Adding a header and footer to the worksheet

Excel 365
Headers and footers are widely used in the Microsoft Word document, but you should know that Excel has headers and footers too.

To add a header and footer in your worksheet, follow the next steps:

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

Header and Footer in Excel 2016

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

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

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

Header and Footer Tools Excel 2016

   3.   Under Header & Footer Tools, on the Design tab, in the Header & Footer Elements group, click the element that you want.

Note: To return to Normal view, on the View tab, in the Workbook Views group, click Normal. You can also click Normal on the status bar:

Normal view in Excel 2016

See also this tip in French: Comment ajouter un en-tête et un pied de page à la feuille de calcul.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.