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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.