How to save formulas when creating templates

[JDV]

I have created a workbook containing two sheets with various formulas for my
organization. I would like to save this as a template to use for each group
however when I delete the current data in order to replace with different
data my formulas are lost. Is there any way to save the formatting and the
formulas of a workbook/worksheet without saving the current data. In
essence, I want to preserve the colors, fonts, set-up, formulas etc but not
the individual cell data.

 

[Gord Dibben]

Create a true Template with the formatting and formulas but no data.

Save as>File Type>Excel Template(*.xlt)

Your users open that template file and a copy is created for them to fill in
data.

They save that copy and your original template is not touched.


Gord Dibben MS Excel MVP

 

[JDV]

Thank you for responding. So in essence I have to retype my formulas after
removing the data so that it ca be saved as such?

 

[David Biddulph]

Gord said, in the post to which you were replying:
"Create a true Template with the formatting and formulas but no data".

He didn't say delete the formulas; he only wanted you to delete the data.

 

[Gord Dibben]

Not necessary to re-type formulas from the current workbook/sheet

Hit F5 and Special>Constants and OK...........if you have titles or text you
want to retain, uncheck that option button before OK'ing

Edit>Clear Contents.

This will leave the formulas in place.

Now save as a Template.


Gord