View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Spacebar creates value error

Click in a populated cell and hit <space, then <enter.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bernard Liengme" wrote in message
...
How does the spacebar 'clear' anything?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dennis1188" wrote in message
...
A3 is the sum total of A1 plus A2
If I clear either A1 or A2 with the spacebar I get a value error. I know

I
can "clear the contents" or enter zero but is there another way around
this
because using the spacebar is better for us.