basic saving formula question

[Peter H]

Sorry for the silly question, but I can't seem to find the answer to this
basic question.

I've created an excel spreadsheet that reconciles consumption/sales figures
on a monthly basis. Rather than create a new workbook each month I would
like to just delete the entries and save all of the formulas and then save
the workbook to a new file. Seems simple enough.

I normally use lotus and have never had a problem doing this. I just choose
to clear the contents, but not the formulas and voila. I've found that w/
excel though no matter how I delete the information in the workbook the
formulas are deleted as well and I end up starting from scratch each month.

What the heck am I missing here?

Peter H

 

[Otto Moehrbach]

Peter
The simplest way to do what you want is to hit the F5 function key (the
GoTo key), click on Special at the bottom of the displayed box, select
Constants, click OK. This selects every cell in the sheet that contains
anything but a formula. Hit the Del or Delete key on your keyboard.
Everything is gone but the formulas. HTH Otto

 

[Peter H]

Peter
The simplest way to do what you want is to hit the F5 function key (the
GoTo key), click on Special at the bottom of the displayed box, select
Constants, click OK. This selects every cell in the sheet that contains
anything but a formula. Hit the Del or Delete key on your keyboard.
Everything is gone but the formulas. HTH Otto

Thanks Otto

Peter H