View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KrispyData KrispyData is offline
external usenet poster
 
Posts: 24
Default 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