Difference between revisions of "Excel Headers and Footers"
From Help Wiki
(Created page with '<div class="intro">75pxHeader and footer options allow you to add page numbers, the date and time, or the name of your file.</div> Headers and f…') |
|||
| (3 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | <div class="intro">[[File:Excel_logo.jpg |left|75px]]Header and footer options allow you to add page numbers, the date and time, or the name of your file.</div> | + | <div class="intro">[[File:Excel_logo.jpg |left|75px]]<br> |
| − | + | Header and footer options allow you to add page numbers, the date and time, or the name of your file.</div> | |
| + | <br> | ||
Headers and footers are only displayed in Page Layout view and on the printed pages. | 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 | 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 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. | ||
[[category:Excel]] | [[category:Excel]] | ||
Latest revision as of 17:54, 30 October 2011
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.
