Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Personal format of an excel spreadsheet as a template?
I need to use the format of an Excel spreadsheet that I have created as a
template for other worksheets in a book and other books. How can I accomplish this, if possible? |
#2
|
|||
|
|||
Create a new workbook with one sheet and format as you wish.
FileSave AsFile TypeTemplate(*.xlt) Name it SHEET(Excel will add the .xlt extension. Store this SHEET.XLT in your XLSTART folder. It will be the default worksheet for InsertWorksheet. Gord Dibben Excel MVP On Wed, 19 Jan 2005 17:29:01 -0800, Nukinhawg wrote: I need to use the format of an Excel spreadsheet that I have created as a template for other worksheets in a book and other books. How can I accomplish this, if possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
In Excel, how can you format for 4 digit years (MM/DD/YYYY)? | Excel Discussion (Misc queries) | |||
How do I change Excel format to pdf format? | Excel Discussion (Misc queries) | |||
Adding a chart to a Word template linked to an Excel doc. | Excel Discussion (Misc queries) | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |