Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
New Worksheets in a template to be pre-formatted.
I an excell template how can I setup formating to be the same for each (new)
worksheet opened. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
New Worksheets in a template to be pre-formatted.
Mohan
Open a new workbook. Customize as you wish. FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT. Store this workbook in the XLSTART folder usually located at........ C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART This will be the default workbook for FileNew Existing workbooks are not affected by these settings. You can also open a new workbook and delete all but one sheet. Customize as you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes the default InsertSheet. More can be found on this in Help under "templates"(no quotes). Gord Dibben Excel MVP On Thu, 22 Dec 2005 17:00:02 -0800, "Mohan De Silva" wrote: I an excell template how can I setup formating to be the same for each (new) worksheet opened. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Paste data repeatedly from different worksheets to a template | Excel Worksheet Functions | |||
How do I merge many identically formatted worksheets into one? | Excel Discussion (Misc queries) | |||
how to reuse formatted worksheets from 2004 in 2005 | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |