Just like a header or footer in Word 2007, you can quickly add a header or footer to a workbook in Excel 2007.  You can add the date, time, filename or any other information you would like to make available to readers of your spreadsheet.

To create a header or footer in Excel 2007:

1) Make sure you are on the “Insert” tab of the ribbon

2) Look for the “Text” group – it will be on the right hand side of the ribbon

3) Click on “Header & Footer”

You will see a new tab appear on the ribbon called “Header & Footer Tools – Design”.  Using the buttons on this tab of the ribbon, you can quickly add:

• Page Number;
• Number of Pages;
• Current Date;
• Current Time;
• File Path;
• File Name;
• Sheet Name; or a
• Picture

To the header or footer of your document.  To switch from the header to the footer, simply click on “Go to Footer” which you will find in the “Navigation” group about half way along the ribbon.

‘till next time!
TNP

Related posts:

1. Add a Footer to your slides in PowerPoint 2007
2. Word 2007: How to add page numbers to your documents
3. Insert a column in Excel 2007
4. Protect a Sheet in Excel 2007
5. Insert a “Date Picker” into your Word 2007 document