How do I set uo a template of formulas in excel

[Guest]

I want to set up a template of calculations I do in excel. Its like- i open
the Excel template sheet, fill in the data and the calculations done
automatically. This will save my time. I have seen that people create a set
of sheets with designed formula and calculations. Every time they open it,
just fill the data and get all the results and graph made by excel. I do not
know what this feature is called on HELP menu. Please guide how I can do it
for myself.
Ajay

 

[Peo Sjoblom]

You need to create all the formulas and make sure the data fields are empty
then save it as *.xlt, then do file open>new and select from the templates
and it will open a copy of the original file with a number like MyTemplate1,
then you can fill in the data and have the formulas do the calculations

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey