View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Mark Lincoln
 
Posts: n/a
Default 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.