Default Header & Footer?

  • Thread starter SouthAfricanStan
  • Start date
S

SouthAfricanStan

Using XP, Office 2003
Without using a template, is it possible to, every time, open a new workbook
with say filename and date in the footer?
If not, will this be possible in Vista/Office2007?
 
D

Dave Peterson

Start a new workbook.
Set up everything you want--headers/footers/layout...
Save it as book.xlt in your XLStart folder.

Then excel will use that when you create a new workbook by clicking on the new
icon on the standard toolbar.

If you want the same thing when you add a new worksheet to an existing workbook,
save another workbook (probably a single sheet???) in that same XLStart
folder--but name it Sheet.xlt.

I haven't used xl2003.
 
Top