Excel Footers

[amberfreed]

Hello Everyone,

Does anyone know how to add a permanent footer to all excel documents? I would like file name, path and date to show up on every excel document I print without adding the footer to each individual workbook.

Thank you in advance!!!

Amber

 

[RoryA]

If you add that information to a template workbook called book.xlt in your XLSTART directory, it will apply to any new workbooks you create (unless you specifically use File-> New...-> New Blank Workbook to create them) but you would have to do it manually for all existing workbooks, or write some code to format them, then run the code each time you need it.
You could also create an add-in that trapped the print event for the application and set up the footer as required.

 

[jim may]

Create of Modify your Book.xlt to include your desired Print Settings. And, of course Store it in your XLStart folder

 

[amberfreed]

Thank you very much for your help!!!