Microsoft Excel Header and Footer - Microsoft Excel

What is Header and Footer in Excel 2010?

Header and Footer

  • The information that appears at the top of each printed page is a header.
  • The information that appears at the bottom of each printed page is the footer.
  • New workbooks do not have headers or footers by default.

Adding Header and Footer

  • Choose Page Setup dialogbox » Header or Footer tab.

set header footer

The predefined header and footer can be choosed or create your custom ones.

  • &[Page] : Displays the page number.
  • &[Pages] : Displays the total number of pages to be printed.
  • &[Date] : Displays the current date.
  • &[Time] : Displays the current time.
  • &[Path]&[File] : Displays the workbook’s complete path and filename.
  • &[File] : Displays the workbook name.
  • &[Tab] : Displays the sheet’s name.

Other Header and Footer Options

In Page Layout view, when a header or footer is selected, the Header & Footer » Design » Options group contains controls let you specify other options :

  • Different First Page : Check this to specify a different header or footer for the first printed page.
  • Different Odd & Even Pages : Check this to specify a different header or footer for odd and even pages.
  • Scale with Document : This is a default option. If checked, the font size in the header and footer will be sized. Accordingly if the document is scaled when printed.
  • Align with Page Margins : This is a default option. If checked, the left header and footer will be aligned with the left margin, and the right header and footer will be aligned with the right margin.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Microsoft Excel Topics