basic saving formula question

  • Thread starter Thread starter Peter H
  • Start date Start date
P

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
 
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
 
Otto Moehrbach said:
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
Click to expand...

Thanks Otto

Peter H
 
Back
Top