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?