Adding a header and footer to the worksheet

Excel 2016 2013 2010 2007 2003
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.   Do one of the following:

  • On the Insert tab, in the Text group, click Header & Footer:
    Header and Footer in Excel 365   or   Header and Footer in Excel 365
  • On the View tab, in the Workbook Views group, click Page Layout:
    Page Layout view in Excel 365

    Excel displays the worksheet in Page Layout view. You can also click Page Layout view Page Layout View in Excel 365 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:

Add Header in Excel 365
Add Footer in Excel 365

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

Header and Footer tab in Excel 365

   3.   On the Header & Footer tab, in the Header & Footer Elements group, select the element that you want.

Note: To return to the Normal view, on the View tab, in the Workbook Views group, click Normal:

Normal view in Excel 365

You can also click Normal on the status bar: Normal view in Excel 365

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

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more