Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 16th 06, 05:45 PM posted to microsoft.public.excel.misc
alanortho
 
Posts: n/a
Default 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

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


  #3   Report Post  
Old March 16th 06, 06:51 PM posted to microsoft.public.excel.misc
alanortho
 
Posts: n/a
Default 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.



  #4   Report Post  
Old March 16th 06, 06:59 PM posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default 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.







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel automatically insert current date in a cell? AdrianXing Excel Worksheet Functions 24 March 23rd 15 02:39 PM
Insert current author's name in cell or footer in Excel?? dneal53 Setting up and Configuration of Excel 1 January 30th 06 05:50 PM
How to insert a picture in the Footer (not the Header) in Excel 20 jmon Excel Worksheet Functions 2 March 17th 05 06:59 AM
Can you change something in Excel to automatically insert an equa. Jeff Excel Discussion (Misc queries) 1 March 10th 05 03:55 PM
How to automate custom footer on all tabs neal august Excel Discussion (Misc queries) 1 March 3rd 05 03:38 PM


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017