template

[HunterN]

Hi!

I have a worksheet that has formulas and data
already in it. I want to make a template out of it, so that the formulas stay and the
data is cleared out. I will then use this
template at the beginning of each fiscal year to create a clean worksheet.

Can you help me with this? Or tell me where to get info on this?

Thanks

[Morrissey]

Hi, Ok Open up the worksheet and go to file click on save as and on the on the save as drop down menu under the enter file name on it select template specify the directory you want it in and volia your done if anyother help please ask sorry if this sounds a bit incoherent

[Parra]

You can save it as a template. File, Save as, and when the save window pops up, change the save file to "template".

To open it go to File, New, and open your template.

I hope this is what you were looking for.

[Jack in the UK]

Hi

Design as required and then save as XXXX.xlt thats the excel extention for template

now re save as theExcelSheet.xls and work on this sheet all formula wil be blank and active in xls as reqd per your design of the xlt.

HTH

[Jack in the UK]

Hi

Design as required and then save as XXXX.xlt thats the excel extention for template

now re save as theExcelSheet.xls and work on this sheet all formula wil be blank and active in xls as reqd per your design of the xlt.

HTH

[Jack in the UK]

Hi

Design as required and then save as XXXX.xlt thats the excel extention for template

now re save as theExcelSheet.xls and work on this sheet all formula wil be blank and active in xls as reqd per your design of the xlt.

HTH

[Jack in the UK]

Hi

Design as required and then save as XXXX.xlt thats the excel extention for template

now re save as theExcelSheet.xls and work on this sheet all formula wil be blank and active in xls as reqd per your design of the xlt.

HTH

[HunterN]

I saved it as a template. But when I look at it it stills has the values that were there originally. The problem is if I clear out the cells the formula is cleared out too.

What do I do?

Thanks, HunterN

[kinkyparamour]

Don't clear the cells containing the formulas. Clear the cells the formula reads.......

[Jack in the UK]

Hi

You need to make a blank template that carries in the formulas req but no data
and work from there,