View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Chris Hoagland
 
Posts: n/a
Default clearing a cell and keeping the formula

protect the worksheet so the formulas stay in it . then you can change or
delete the data and the formula stays..
"genevieveg" wrote
in message ...

hi Im new to excel I seem to lose my formula's everytime I go back to
enter some data that I may enter wrong for example I have put the
formula in and go back and put a number in the cell and find it's the
wrong # so I backspace or hit delete and I lose my formula and clear
the cell what am I doing wrong??:)


--
genevieveg
------------------------------------------------------------------------
genevieveg's Profile:

http://www.excelforum.com/member.php...o&userid=30333
View this thread: http://www.excelforum.com/showthread...hreadid=499995