HEADERS AND FOOTERS

What are Excel Headers and Footers?
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.
Add a Custom Header in Excel
In Excel, a header is a line of text that prints at the top of each page in the spreadsheet.
A header is used to add information to a spreadsheet before it is printed. Custom headers can be used to add specific information, such as a title, or description of the worksheet.
A header can appear in three locations on the spreadsheet - the top left corner of each page, the top center, and the top right corner of each page.

Adding a Custom Header in Excel
To add a header: 1. Click on the Insert tab. 2. Click on the Header & Footer option in the ribbon. 3. The spreadsheet switches to page layout view. 4. Three boxes can be seen above the worksheet page. 5. By default, the center box is highlighted. 6. Click with the mouse on either of the side boxes to change the location of the header if desired. 7. Type in the header information.
Add a Custom Footer in Excel
In Excel , a footer is a line of text that prints at the bottom of each page in the spreadsheet.
A footer is used to add information to a spreadsheet before it is printed. Custom footers can be used to add specific information, such as the spreadsheet author, or a description of the worksheet.
A footer can appear in three locations on the spreadsheet - the bottom left corner of each page, the bottom center, and the bottom right corner of each page.

Adding a Custom Footer in Excel
To add a footer: 1. Click on the Insert tab. 2. Click on the Header & Footer option in the ribbon. 3.