ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can excel automatically insert a custom footer in all files (https://www.excelbanter.com/excel-discussion-misc-queries/77750-can-excel-automatically-insert-custom-footer-all-files.html)

alanortho March 16th 06 05:45 PM

can excel automatically insert a custom footer in all files
 
I would like all my worksheets to have the file name and date created printed
in a footer on the bottom of the page

Doug Kanter March 16th 06 05:59 PM

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
printed
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.



alanortho March 16th 06 06:51 PM

can excel automatically insert a custom footer in all files
 
Thank you very much for that helpful information!! :)

"Doug Kanter" wrote:

"alanortho" wrote in message
...
I would like all my worksheets to have the file name and date created
printed
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.




Doug Kanter March 16th 06 06:59 PM

can excel automatically insert a custom footer in all files
 
That came directly from Excel's help system, by the way. The F1 key is your
friend. :-)

"alanortho" wrote in message
...
Thank you very much for that helpful information!! :)

"Doug Kanter" wrote:

"alanortho" wrote in message
...
I would like all my worksheets to have the file name and date created
printed
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.







All times are GMT +1. The time now is 10:24 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com