What are Excel Headers and Footers?

Question: What are Excel Headers and Footers?

Answer: In Microsoft Excel, headers and footers are lines of text that print at the top (header) and bottom (footer) of each page in the spreadsheet.

They contain descriptive text such as titles, dates, and/or page numbers. They are used to add information to a spreadsheet that is being printed.

View Headers and Footers

• Headers and footers are not visible in the normal worksheet view.
  
  
  
• To view a header or footer before printing the spreadsheet, use the Print Preview option.

Note: To use Print Preview in Excel, you must have a printer installed on your computer.

Headers and Footers Locations

• A header or footer can contain up to three pieces of information. This information can appear in three locations on the page.
  
  
• For headers, the locations are the top left corner, the top center, and the top right corner of the page.
  
  
• For footers, the locations are the bottom left corner, the bottom center, and the bottom right corner of the page.

Preset or Custom Headers and Footers

• Excel has several preset headers and footers that you can use.
  
  
• These standard options include the sheet name, date, time, page number, and file name.
  
  
• There is also an option for creating your own custom headers or footers that can include text, graphics, or other spreadsheet data.
  
  

  How to add headers and footers to a worksheet:

  1. Choose File > Page Setup from the menu to open the Page Setup dialog box.
     
     
  2. Select the Header-Footer tab.
     
     
  3. Select from the preset or custom header - footer options.
     
     
  4. Create the header or footer.
     
     
  5. Preview in Print Preview.