I would like Excel to print the date and file path on my document as a default setting so I would not have to set up a header/footer each time. How do I do this?
Set up a sheet to be how you want your default sheet to be - including any
printing options like headers, footers, and font, size etc. You should then
save this as a template in your XLStart folder (on my PC it is C:\Program
Files\Microsoft Office\Office\XLStart) as book.xlt
Any new books you open will be set with these defaults.
You can also do the same with sheet.xlt which will set the defaults for when
you insert a new sheet into a workbook.
--
Andy.
Nick G said:
I would like Excel to print the date and file path on my document as a
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
