Creating templates from existing forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Attach Excel Template to Existing Spreadsheet 1
attach an Excel 2007 template 5
Excel How to add a calendar month to and existing excel file created in a template 1
Outlook Remove To and CC from Outlook template 1
edited spreadsheet saves as template 9
add personal template to the insert worksheet dialog box 2
HOW TO AUTOMATICALLY GENERATE NUMBERS IN EXCEL 1
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top