Difference between revisions of "Excel Headers and Footers"
From Help Wiki
| Line 4: | Line 4: | ||
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 | 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. | 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 To Use This: | ||
Revision as of 09:32, 26 October 2011
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.
