software

Can anyone tell me how I can create a worksheet template, with the fonts,
layout, etc that I specify, that will be inserted into a workbook when I
click Insert/Worksheet? I have already tried creating a single sheet
document, which I have saved as an .xlt file in C:\Program Files\Microsoft
Office\Office10\XLStart, but this wasn't picked up when I used the Insert
command. I saved the file as 'worksheet template.xlt'.
Thanks for your help.
Janet


quot;Janet Tquot; gt; wrote in message
...
gt; Can anyone tell me how I can create a worksheet template, with the fonts,
gt; layout, etc that I specify, that will be inserted into a workbook when I
gt; click Insert/Worksheet? I have already tried creating a single sheet
gt; document, which I have saved as an .xlt file in C:\Program Files\Microsoft
gt; Office\Office10\XLStart, but this wasn't picked up when I used the Insert
gt; command. I saved the file as 'worksheet template.xlt'.
gt; Thanks for your help.
gt; Janet
gt;
gt;
gt;

Straight from the Excel help system, accessible from your menu:

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

Wrong XLSTART folder.

Try this one................

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

The other steps you have taken look correct. Make sure you save as SHEET.XLTGord Dibben MS Excel MVP

On Thu, 9 Mar 2006 05:12:27 -0800, Janet T gt;
wrote:

gt;Can anyone tell me how I can create a worksheet template, with the fonts,
gt;layout, etc that I specify, that will be inserted into a workbook when I
gt;click Insert/Worksheet? I have already tried creating a single sheet
gt;document, which I have saved as an .xlt file in C:\Program Files\Microsoft
gt;Office\Office10\XLStart, but this wasn't picked up when I used the Insert
gt;command. I saved the file as 'worksheet template.xlt'.
gt;Thanks for your help.
gt;Janet
gt;
gt;Doug
Thanks for your help with this. I'm sure I followed all of these steps
correctly, but I will double-check.
Thanks for taking the trouble to reply.
Regards
Janetquot;Doug Kanterquot; wrote:

gt;
gt; quot;Janet Tquot; gt; wrote in message
gt; ...
gt; gt; Can anyone tell me how I can create a worksheet template, with the fonts,
gt; gt; layout, etc that I specify, that will be inserted into a workbook when I
gt; gt; click Insert/Worksheet? I have already tried creating a single sheet
gt; gt; document, which I have saved as an .xlt file in C:\Program Files\Microsoft
gt; gt; Office\Office10\XLStart, but this wasn't picked up when I used the Insert
gt; gt; command. I saved the file as 'worksheet template.xlt'.
gt; gt; Thanks for your help.
gt; gt; Janet
gt; gt;
gt; gt;
gt; gt;
gt;
gt; Straight from the Excel help system, accessible from your menu:
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

Gord
Thanks for your help with this. I will save as sheet.xlt. I have also
found out that you can right-click the sheet tab and use Insert from there to
select a sheet in the templates window.
Thanks again.
Regards
Janetquot;Gord Dibbenquot; wrote:

gt; Janet
gt;
gt; Wrong XLSTART folder.
gt;
gt; Try this one................
gt;
gt; C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
gt;
gt; The other steps you have taken look correct. Make sure you save as SHEET.XLT
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Thu, 9 Mar 2006 05:12:27 -0800, Janet T gt;
gt; wrote:
gt;
gt; gt;Can anyone tell me how I can create a worksheet template, with the fonts,
gt; gt;layout, etc that I specify, that will be inserted into a workbook when I
gt; gt;click Insert/Worksheet? I have already tried creating a single sheet
gt; gt;document, which I have saved as an .xlt file in C:\Program Files\Microsoft
gt; gt;Office\Office10\XLStart, but this wasn't picked up when I used the Insert
gt; gt;command. I saved the file as 'worksheet template.xlt'.
gt; gt;Thanks for your help.
gt; gt;Janet
gt; gt;
gt; gt;
gt;
gt;

You used a different name. If you want the template to be the one Excel
defaults to when you simply want a new, blank sheet, you must name it
quot;sheet.xltquot;. You can give other templates any name you want, but for that
special sheet, the name is important. The instructions I copied came from
the Excel 2000 help system. Not sure if later versions are different, so
check your help thing. I simply put the words quot;default templatequot; in the
search window, and came up with these instructions.

quot;Jittyquot; gt; wrote in message
...
gt; Doug
gt; Thanks for your help with this. I'm sure I followed all of these steps
gt; correctly, but I will double-check.
gt; Thanks for taking the trouble to reply.
gt; Regards
gt; Janet
gt;
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt;
gt;gt; quot;Janet Tquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Can anyone tell me how I can create a worksheet template, with the
gt;gt; gt; fonts,
gt;gt; gt; layout, etc that I specify, that will be inserted into a workbook when
gt;gt; gt; I
gt;gt; gt; click Insert/Worksheet? I have already tried creating a single sheet
gt;gt; gt; document, which I have saved as an .xlt file in C:\Program
gt;gt; gt; Files\Microsoft
gt;gt; gt; Office\Office10\XLStart, but this wasn't picked up when I used the
gt;gt; gt; Insert
gt;gt; gt; command. I saved the file as 'worksheet template.xlt'.
gt;gt; gt; Thanks for your help.
gt;gt; gt; Janet
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt; Straight from the Excel help system, accessible from your menu:
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
doug
Once again, thanks for putting so much effort into your reply. I really
appreciate it (I need all the help I can get with Excel!)
Best regards
Janetquot;Doug Kanterquot; wrote:

gt; You used a different name. If you want the template to be the one Excel
gt; defaults to when you simply want a new, blank sheet, you must name it
gt; quot;sheet.xltquot;. You can give other templates any name you want, but for that
gt; special sheet, the name is important. The instructions I copied came from
gt; the Excel 2000 help system. Not sure if later versions are different, so
gt; check your help thing. I simply put the words quot;default templatequot; in the
gt; search window, and came up with these instructions.
gt;
gt; quot;Jittyquot; gt; wrote in message
gt; ...
gt; gt; Doug
gt; gt; Thanks for your help with this. I'm sure I followed all of these steps
gt; gt; correctly, but I will double-check.
gt; gt; Thanks for taking the trouble to reply.
gt; gt; Regards
gt; gt; Janet
gt; gt;
gt; gt;
gt; gt; quot;Doug Kanterquot; wrote:
gt; gt;
gt; gt;gt;
gt; gt;gt; quot;Janet Tquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Can anyone tell me how I can create a worksheet template, with the
gt; gt;gt; gt; fonts,
gt; gt;gt; gt; layout, etc that I specify, that will be inserted into a workbook when
gt; gt;gt; gt; I
gt; gt;gt; gt; click Insert/Worksheet? I have already tried creating a single sheet
gt; gt;gt; gt; document, which I have saved as an .xlt file in C:\Program
gt; gt;gt; gt; Files\Microsoft
gt; gt;gt; gt; Office\Office10\XLStart, but this wasn't picked up when I used the
gt; gt;gt; gt; Insert
gt; gt;gt; gt; command. I saved the file as 'worksheet template.xlt'.
gt; gt;gt; gt; Thanks for your help.
gt; gt;gt; gt; Janet
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt; Straight from the Excel help system, accessible from your menu:
gt; gt;gt;
gt; gt;gt; Create a sheet template for new worksheets
gt; gt;gt; 1.. Create a workbook that contains one worksheet. On the worksheet,
gt; gt;gt; include the formatting, styles, text, and other information you want to
gt; gt;gt; appear on all new sheets of the same type.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; 2.. On the File menu, click Save As.
gt; gt;gt; Show Me
gt; gt;gt;
gt; gt;gt; 3.. In the Save as type box, click Template (*.xlt).
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; 4.. In the Save in box, select the folder where you want to store the
gt; gt;gt; template.
gt; gt;gt; To create the default worksheet template, select either the XLStart
gt; gt;gt; folder
gt; gt;gt; or the alternate startup folder. The XLStart folder is usually
gt; gt;gt; C:\os\Profiles\user_name\Application Data\Microsoft\Excel\XLStart
gt; gt;gt; where os is the operating system folder - for example, Windows.
gt; gt;gt;
gt; gt;gt; To create a custom sheet template, select the Templates folder, which
gt; gt;gt; is
gt; gt;gt; usually
gt; gt;gt; C:\os\Profiles\user_name\Application Data\Microsoft\Templates
gt; gt;gt; where os is the operating system folder - for example, Windows.
gt; gt;gt;
gt; gt;gt; 5.. In the File name box, type sheet to create a template for default
gt; gt;gt; worksheets.
gt; gt;gt; To create a custom sheet template, type any valid file name.
gt; gt;gt;
gt; gt;gt; 6.. Click Save, and then click Close on the File menu
gt;
gt;
gt;

You're welcome. It really WAS a lot of effort, Janet. I had to move my
coffee cup in order to type. pant...pant..pant....quot;Jittyquot; gt; wrote in message
...
gt; doug
gt; Once again, thanks for putting so much effort into your reply. I really
gt; appreciate it (I need all the help I can get with Excel!)
gt; Best regards
gt; Janet
gt;
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt; You used a different name. If you want the template to be the one Excel
gt;gt; defaults to when you simply want a new, blank sheet, you must name it
gt;gt; quot;sheet.xltquot;. You can give other templates any name you want, but for that
gt;gt; special sheet, the name is important. The instructions I copied came from
gt;gt; the Excel 2000 help system. Not sure if later versions are different, so
gt;gt; check your help thing. I simply put the words quot;default templatequot; in the
gt;gt; search window, and came up with these instructions.
gt;gt;
gt;gt; quot;Jittyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Doug
gt;gt; gt; Thanks for your help with this. I'm sure I followed all of these steps
gt;gt; gt; correctly, but I will double-check.
gt;gt; gt; Thanks for taking the trouble to reply.
gt;gt; gt; Regards
gt;gt; gt; Janet
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Doug Kanterquot; wrote:
gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Janet Tquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Can anyone tell me how I can create a worksheet template, with the
gt;gt; gt;gt; gt; fonts,
gt;gt; gt;gt; gt; layout, etc that I specify, that will be inserted into a workbook
gt;gt; gt;gt; gt; when
gt;gt; gt;gt; gt; I
gt;gt; gt;gt; gt; click Insert/Worksheet? I have already tried creating a single
gt;gt; gt;gt; gt; sheet
gt;gt; gt;gt; gt; document, which I have saved as an .xlt file in C:\Program
gt;gt; gt;gt; gt; Files\Microsoft
gt;gt; gt;gt; gt; Office\Office10\XLStart, but this wasn't picked up when I used the
gt;gt; gt;gt; gt; Insert
gt;gt; gt;gt; gt; command. I saved the file as 'worksheet template.xlt'.
gt;gt; gt;gt; gt; Thanks for your help.
gt;gt; gt;gt; gt; Janet
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt; Straight from the Excel help system, accessible from your menu:
gt;gt; gt;gt;
gt;gt; gt;gt; Create a sheet template for new worksheets
gt;gt; gt;gt; 1.. Create a workbook that contains one worksheet. On the worksheet,
gt;gt; gt;gt; include the formatting, styles, text, and other information you want
gt;gt; gt;gt; to
gt;gt; gt;gt; appear on all new sheets of the same type.
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; 2.. On the File menu, click Save As.
gt;gt; gt;gt; Show Me
gt;gt; gt;gt;
gt;gt; gt;gt; 3.. In the Save as type box, click Template (*.xlt).
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; 4.. In the Save in box, select the folder where you want to store
gt;gt; gt;gt; the
gt;gt; gt;gt; template.
gt;gt; gt;gt; To create the default worksheet template, select either the XLStart
gt;gt; gt;gt; folder
gt;gt; gt;gt; or the alternate startup folder. The XLStart folder is usually
gt;gt; gt;gt; C:\os\Profiles\user_name\Application Data\Microsoft\Excel\XLStart
gt;gt; gt;gt; where os is the operating system folder - for example, Windows.
gt;gt; gt;gt;
gt;gt; gt;gt; To create a custom sheet template, select the Templates folder,
gt;gt; gt;gt; which
gt;gt; gt;gt; is
gt;gt; gt;gt; usually
gt;gt; gt;gt; C:\os\Profiles\user_name\Application Data\Microsoft\Templates
gt;gt; gt;gt; where os is the operating system folder - for example, Windows.
gt;gt; gt;gt;
gt;gt; gt;gt; 5.. In the File name box, type sheet to create a template for
gt;gt; gt;gt; default
gt;gt; gt;gt; worksheets.
gt;gt; gt;gt; To create a custom sheet template, type any valid file name.
gt;gt; gt;gt;
gt;gt; gt;gt; 6.. Click Save, and then click Close on the File menu
gt;gt;
gt;gt;
gt;gt;


quot;Janet Tquot; wrote:

gt; Can anyone tell me how I can create a worksheet template, with the fonts,
gt; layout, etc that I specify, that will be inserted into a workbook when I
gt; click Insert/Worksheet? I have already tried creating a single sheet
gt; document, which I have saved as an .xlt file in C:\Program Files\Microsoft
gt; Office\Office10\XLStart, but this wasn't picked up when I used the Insert
gt; command. I saved the file as 'worksheet template.xlt'.
gt; Thanks for your help.
gt; Janet
gt;
gt;
gt;