View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jitty
 
Posts: n/a
Default Worksheet Template

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
Janet


"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

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

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