» Adding a Reference to Header/Footer in excel 2007

To add a reference such as a workbook name, a sheet name,
a printing date and time, or a path in one sheet:

1. Select Page Layout -> Print Titles (in Page Setup Group) -> Header/Footer tab.
2. Select Custom Footer.
3. Select a section and click the Tab, File, Path, Time and Date commands,
and then click OK.

To add a reference such as a workbook name, a sheet name, a printing date and time,
or a path to all the sheets in a workbook:

1. Select a sheet tab, right click and select Select All Sheets.
2. Follow the steps above.
3. Select the sheet tab, right click and select Ungroup Sheets.