Excel should allow delete cell's value but leave formula alone.
I don't understand what purpose such a thing would serve. If I don't
want a value in a cell, I do as Dave has suggested by writing my
formula to return nothing if the cell should look blank. Or delete the
formula.
If you don't want to see the value returned by a formula, I suppose you
could use the same color for the cell text and cell background.
|