Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to create a template and I'm not sure of how to do it.
|
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
If you're talking about a true XL template, where you automatically open a
*copy* of the original by clicking in: <File <New And then click on the template name in the "General Window", thus preserving the original from accidental revisions, it's really quite simple. After creating your sheet, when it comes time for the final save, click: <File <Save As And at the bottom of the window, expand the "Save As Type" box and click on: "Template (*.xlt)" Make sure you've entered an appropriate name for the template, Then <Save Now, just click on <File <New, and click on the name you created, and a copy will open, with the same name as the template, but with a "1" appended to the end of the name. You can open as many copies as you wish at the same time, where each will have an incremented number appended to it. After you're finished with the template, and it's ready to save, you can rename it and save it to the proper folder. To revise the template itself, just make your changes to one of the copies, then again click on "Template (*.xlt)" in the "Save As Type" box, *BUT* remove the appended number from the end of the name, so that you have the exact *original* name displayed, then click on <Save. You'll get the dialog about the file already existing, and do you want to replace it, to which you answer "Yes". -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "misstiny99" wrote in message ... I need to create a template and I'm not sure of how to do it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW TO CREATE A LETTER TEMPLATE IN EXCEL? | Excel Discussion (Misc queries) | |||
=IF problem | Excel Discussion (Misc queries) | |||
Create template that ignors data list rules | New Users to Excel | |||
a template in Excel 2000 called mimic.xlt? | Excel Discussion (Misc queries) | |||
how to create and use a new spreadsheet based on a template | Excel Discussion (Misc queries) |