Header and Footer in Excel Tutorial


Header and Footer

Header and Footer allow you to add some text on the top or the bottom of the each sheet that is contained in the Excel File. Header is used for printing the text on top of page while Footer is used from printing on the bottom of the page. By default, both Header and Footer are blank.

Adding Header and Footer

  • You can find the Tab for Header and Footer in the Page Setup dialog box.

Microsoft Excel has a predefined set of header and footer for which you can choose one. You can also design your own.

  • &[Page] : It shows the page number.
  • &[Pages] : It shows the total count of the pages to be printed.
  • &[Date] : It shows the current date
  • &[Time] : It shows the current time
  • &[Path]&[File] : This option lets you put the filename along with the complete path of the workbook.
  • &[File] : This option shows the name of the workbook.
  • &[Tab] : This option shows the name of the current sheet.

Other header and footer options

You can explore several other options in Header and Footer by going into the option of Header and Footer in the Page Layout view. Following are the options available.

  • Different First Page: This option allows you to set a different header and footer for the first page than other pages.
  • Different Odd & Even Pages: This option allows you to set two different header and footer for even and odd pages separately.
  • Scale with Document: This option allows Excel to change the font size of the text in the header and footer to fit the content in the available space. This option is active by default. 
  • Align with Page Margins: This option set the alignment of the header and footer according to the margins. In case of the left alignment, the header and footer shifts towards the left margin and vice versa. This is also the default option.