Default Header & Footer?

  • Thread starter Thread starter SouthAfricanStan
  • Start date 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?
 
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.
 

Ask a Question

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.

Ask a Question

Back
Top