Excel Headers and Footers

Header and footer options allow you to add page numbers, the date and time, or the name of your file.

Headers and footers are only displayed in Page Layout view and on the printed pages. There are three sections of header and footer, left, center and right. Click on each section and begin typing the details that you want to appear on the header You can also insert various header and footer items like Page numbers, Number of pages, Current Date, Current Time, File Path, File Name, Sheet name and picture.

When To Use This:

• When you want to add a date or time stamp on each page.

• When you want to add page numbers.

• When you want to put titles of the spreadsheet.