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, Excel 2010 or Excel 2013:
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
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!