software

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

quot;alanorthoquot; gt; wrote in message
...
gt;I would like all my worksheets to have the file name and date created
gt;printed
gt; 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
template.
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
usually
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
worksheets.
To create a custom sheet template, type any valid file name.

6.. Click Save, and then click Close on the File menu.
Thank you very much for that helpful information!!

quot;Doug Kanterquot; wrote:

gt; quot;alanorthoquot; gt; wrote in message
gt; ...
gt; gt;I would like all my worksheets to have the file name and date created
gt; gt;printed
gt; gt; in a footer on the bottom of the page
gt;
gt; Create a new default worksheet template that contains the footer you want.
gt; Then, any time you start a new sheet, it'll have the footer. Here are the
gt; steps involved in making a default template:
gt;
gt; Create a sheet template for new worksheets
gt; 1.. Create a workbook that contains one worksheet. On the worksheet,
gt; include the formatting, styles, text, and other information you want to
gt; appear on all new sheets of the same type.
gt;
gt;
gt; 2.. On the File menu, click Save As.
gt; Show Me
gt;
gt; 3.. In the Save as type box, click Template (*.xlt).
gt;
gt;
gt; 4.. In the Save in box, select the folder where you want to store the
gt; template.
gt; To create the default worksheet template, select either the XLStart folder
gt; or the alternate startup folder. The XLStart folder is usually
gt; C:\os\Profiles\user_name\Application Data\Microsoft\Excel\XLStart
gt; where os is the operating system folder - for example, Windows.
gt;
gt; To create a custom sheet template, select the Templates folder, which is
gt; usually
gt; C:\os\Profiles\user_name\Application Data\Microsoft\Templates
gt; where os is the operating system folder - for example, Windows.
gt;
gt; 5.. In the File name box, type sheet to create a template for default
gt; worksheets.
gt; To create a custom sheet template, type any valid file name.
gt;
gt; 6.. Click Save, and then click Close on the File menu.
gt;
gt;
gt;

That came directly from Excel's help system, by the way. The F1 key is your
friend. :-)

quot;alanorthoquot; gt; wrote in message
...
gt; Thank you very much for that helpful information!!
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt; quot;alanorthoquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I would like all my worksheets to have the file name and date created
gt;gt; gt;printed
gt;gt; gt; in a footer on the bottom of the page
gt;gt;
gt;gt; Create a new default worksheet template that contains the footer you
gt;gt; want.
gt;gt; Then, any time you start a new sheet, it'll have the footer. Here are the
gt;gt; steps involved in making a default template:
gt;gt;
gt;gt; Create a sheet template for new worksheets
gt;gt; 1.. Create a workbook that contains one worksheet. On the worksheet,
gt;gt; include the formatting, styles, text, and other information you want to
gt;gt; appear on all new sheets of the same type.
gt;gt;
gt;gt;
gt;gt; 2.. On the File menu, click Save As.
gt;gt; Show Me
gt;gt;
gt;gt; 3.. In the Save as type box, click Template (*.xlt).
gt;gt;
gt;gt;
gt;gt; 4.. In the Save in box, select the folder where you want to store the
gt;gt; template.
gt;gt; To create the default worksheet template, select either the XLStart
gt;gt; folder
gt;gt; or the alternate startup folder. The XLStart folder is usually
gt;gt; C:\os\Profiles\user_name\Application Data\Microsoft\Excel\XLStart
gt;gt; where os is the operating system folder - for example, Windows.
gt;gt;
gt;gt; To create a custom sheet template, select the Templates folder, which
gt;gt; is
gt;gt; usually
gt;gt; C:\os\Profiles\user_name\Application Data\Microsoft\Templates
gt;gt; where os is the operating system folder - for example, Windows.
gt;gt;
gt;gt; 5.. In the File name box, type sheet to create a template for default
gt;gt; worksheets.
gt;gt; To create a custom sheet template, type any valid file name.
gt;gt;
gt;gt; 6.. Click Save, and then click Close on the File menu.
gt;gt;
gt;gt;
gt;gt;