View Single Post
  #2   Report Post  
Old March 16th 06, 05:59 PM posted to microsoft.public.excel.misc
Doug Kanter
Posts: n/a
Default can excel automatically insert a custom footer in all files

"alanortho" wrote in message
I would like all my worksheets to have the file name and date created
in a footer on the bottom of the page

Create a new default worksheet template that contains the footer you want.
Then, any time you start a new sheet, it'll have the footer. Here are the
steps involved in making a default template:

Create a sheet template for new worksheets
1.. Create a workbook that contains one worksheet. On the worksheet,
include the formatting, styles, text, and other information you want to
appear on all new sheets of the same type.

2.. On the File menu, click Save As.
Show Me

3.. In the Save as type box, click Template (*.xlt).

4.. In the Save in box, select the folder where you want to store the
To create the default worksheet template, select either the XLStart folder
or the alternate startup folder. The XLStart folder is usually
C:\os\Profiles\user_name\Application Data\Microsoft\Excel\XLStart
where os is the operating system folder - for example, Windows.

To create a custom sheet template, select the Templates folder, which is
C:\os\Profiles\user_name\Application Data\Microsoft\Templates
where os is the operating system folder - for example, Windows.

5.. In the File name box, type sheet to create a template for default
To create a custom sheet template, type any valid file name.

6.. Click Save, and then click Close on the File menu.