Make footers a default
 

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?

Make footers a default
 

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 wrote:

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

Make footers a default
 

Perfect! Thank you.

"Dave Peterson" wrote:

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 wrote:

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