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?

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