Locking Formulas to Cells
 

I don't know if I am using the correct terminology but this is what I
want to do: I have placed formulas in multiple columns that calculate
my sales numbers for a bid. The problem I am running into is that I
change the bids for every person and when I clear a cell is clears the
formula from it as well. Is there a way for me to clear cells without
deleting the formula I have placed inside it? I know that I can just
grab the first cell in the column and drag it down to re-load the
formula in that column but I don't want to have to do that. I want the
formulas permenant and the data I enter to be able to be changed.
Suggestions?


--
spartikus
------------------------------------------------------------------------
spartikus's Profile: http://www.excelforum.com/member.php...o&userid=32272
View this thread: http://www.excelforum.com/showthread...hreadid=525345

Locking Formulas to Cells
 

You can do Edit | Go to (or F5) then click Special and Constants, then
when you click OK only the cells which contain numbers (no formulae)
will be highlighted. Then you can just press the <delete key to clear
them.

You might also want to think about unlocking the cells where your data
is entered and then protecting the worksheet (no need for a password)
to prevent accidental deletion of a formula.

Hope this helps.

Pete