Make footers a default

[KrispyData]

I want all my files to have have a footer, but sometimes forget to do it! Is
there a way to set up Excel so that every new document will automatically
have a file name footer?

 

[Dave Peterson]

Saved from a previous post:

You could create a workbook template named book.xlt and store it in your XLStart
folder. You can name the sheets whatever you want (and do other stuff, too --
print headers/footers/margins).

In xl2003, a new workbook will be created based on this workbook when you click
on the New Icon on the standard toolbar.

You could also create another template named sheet.xlt. Any new worksheet you
add to an existing workbook will inherit its setting.

 

[KrispyData]

Perfect! Thank you.

Saved from a previous post:

You could create a workbook template named book.xlt and store it in your XLStart
folder. You can name the sheets whatever you want (and do other stuff, too --
print headers/footers/margins).

In xl2003, a new workbook will be created based on this workbook when you click
on the New Icon on the standard toolbar.

You could also create another template named sheet.xlt. Any new worksheet you
add to an existing workbook will inherit its setting.