Home |
Search |
Today's Posts |
#1
|
|||
|
|||
New sheets using excel templates
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? |
#2
|
|||
|
|||
New sheets using excel templates
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 jok666 wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
New sheets using excel templates
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. "Debra Dalgleish" wrote: 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 jok666 wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
New sheets using excel templates
Yes, sheet.xlt would be used if you choose InsertWorksheet 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. jok666 wrote: 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. "Debra Dalgleish" wrote: 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 jok666 wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
New sheets using excel templates
Debra, you're an absolute star. Thanks a million. That worked a treat. Go on
the Scots. "Debra Dalgleish" wrote: Yes, sheet.xlt would be used if you choose InsertWorksheet 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. jok666 wrote: 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. "Debra Dalgleish" wrote: 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 jok666 wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
New sheets using excel templates
You're welcome! Thanks for letting me know that it worked.
jok666 wrote: Debra, you're an absolute star. Thanks a million. That worked a treat. Go on the Scots. "Debra Dalgleish" wrote: Yes, sheet.xlt would be used if you choose InsertWorksheet 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. jok666 wrote: 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. "Debra Dalgleish" wrote: 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 jok666 wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTOMATING JOB SHEETS IN EXCEL | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Problem downloading Excel templates | New Users to Excel | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
E-mailing excel templates? | Excel Discussion (Misc queries) |