Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
misstiny99
 
Posts: n/a
Default How do I create a template for excel 2000?

I need to create a template and I'm not sure of how to do it.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ragdyer
 
Posts: n/a
Default How do I create a template for excel 2000?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW TO CREATE A LETTER TEMPLATE IN EXCEL? Ravindra.C Excel Discussion (Misc queries) 1 January 30th 06 05:25 PM
=IF problem EdoZwart Excel Discussion (Misc queries) 5 January 5th 06 04:29 PM
Create template that ignors data list rules Cmac via OfficeKB.com New Users to Excel 0 November 5th 05 06:57 AM
a template in Excel 2000 called mimic.xlt? mike Excel Discussion (Misc queries) 0 September 10th 05 07:41 PM
how to create and use a new spreadsheet based on a template Shady Excel Discussion (Misc queries) 3 April 3rd 05 10:50 PM


All times are GMT +1. The time now is 05:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"