New sheets using excel templates

J

jok666

I've made a sheet template in excel. When I open a new file using this
template, sheet 1 appears as formated. But when I go to insert a new sheet,
a normal blank sheet appears as opposed to the expected formated one. Any
ideas?
 
D

Debra Dalgleish

If you want new sheets to be inserted with the same settings, you can
create a sheet template.

Follow the steps for creating a workbook template, but:
-- create a workbook with only one sheet
-- save as Sheet.xlt
 
J

jok666

High Debra. Thank you so much for going out of your way to answer my query.
One qustion though. Won't sheet.xlt be a default sheet for all excel files I
open? I would like to have a custom template for occasional use only. The
rest of the time I just want the usual blank worksheet.
 
D

Debra Dalgleish

Yes, sheet.xlt would be used if you choose Insert>Worksheet in any workbook.

Instead, assuming your sheet template contains only one worksheet, you
could right-click on a sheet tab, and choose Insert.
Select your template, and click OK.
 
J

jok666

Debra, you're an absolute star. Thanks a million. That worked a treat. Go on
the Scots.
 
Top