ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating templates from existing forms (https://www.excelbanter.com/excel-discussion-misc-queries/2238-creating-templates-existing-forms.html)

Marinasun

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.

JulieD

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.




papou

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.




Peo Sjoblom

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.


Dave Peterson

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


All times are GMT +1. The time now is 10:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com