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