Adding a header and footer to the worksheet

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:
    or  
• On the View tab, in the Workbook Views group, click Page Layout:
  

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

   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:

You can also click Normal on the status bar:

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