Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Marinasun
 
Posts: n/a
Default Creating templates from existing forms

How do I take a perfect spreadsheet and make it a template. I have created a
spredsheet that has all of the data I need in my template, so I don't want to
recreate the wheel.
  #2   Report Post  
papou
 
Posts: n/a
Default

Hello
File, Save As, File Type = Template (*.xlt)
HTH
Cordially
Pascal

"Marinasun" a écrit dans le message de
news: ...
How do I take a perfect spreadsheet and make it a template. I have
created a
spredsheet that has all of the data I need in my template, so I don't want
to
recreate the wheel.



  #3   Report Post  
JulieD
 
Posts: n/a
Default

Hi

choose file / save as
under files of type choose template ... it should automatically go to the
correct folder

to access it
choose file / new - if you're using ver 97/2000 you should see your template
if you're using ver 2002/2003 you will probably have to click on "On my
computer" - under "new from template" on the task pane (i think the wording
is slightly different for 2002 & 2003 )

Cheers
JulieD


"Marinasun" wrote in message
...
How do I take a perfect spreadsheet and make it a template. I have
created a
spredsheet that has all of the data I need in my template, so I don't want
to
recreate the wheel.



  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Filesave as*.xlt

Regards,

Peo Sjoblom

"Marinasun" wrote:

How do I take a perfect spreadsheet and make it a template. I have created a
spredsheet that has all of the data I need in my template, so I don't want to
recreate the wheel.

  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default

One more option.

Mark it readonly in windows explorer.
Then just open it and save it as a new name whenever you need a new workbook.

(You don't actually need to mark it readonly, but it might be a tad safer that
way.)

Marinasun wrote:

How do I take a perfect spreadsheet and make it a template. I have created a
spredsheet that has all of the data I need in my template, so I don't want to
recreate the wheel.


--

Dave Peterson


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
Pivot Table Creating New Columns that Subtract Two Existing Columns den4673 Excel Discussion (Misc queries) 3 December 17th 04 01:31 PM
Creating new worksheet from existing ddpen Excel Discussion (Misc queries) 2 December 1st 04 10:35 PM
Creating Templates gwj248 Excel Discussion (Misc queries) 1 November 30th 04 11:42 AM


All times are GMT +1. The time now is 11:59 PM.

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"