View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default Delete cell memory

Tools/ Options/ Edit
Uncheck: Enable AutoComplete for cell values.
--
David Biddulph

"Bhiravi" wrote in message
...
I have a form set up to accept Y or N values input by the user. However,
when
the user puts in an N value, the spreadsheet auto enters a value beginning
with N that was entered into another cell. Ie. it is auto inputting from
memory I'm assuming? How do I erase this, so that when the user puts in
the
input, Excel does not assume what the user is typing?