Creating templates from existing forms

M

Marinasun

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.
 
J

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
 
D

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.)
 
Top