View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Delete cell memory

Like it's autocompleting your entry for you?

Tools|Options|Edit tab|uncheck "enable autocomplete for cell values"

(I hate this for the same reason!)

Bhiravi wrote:

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?


--

Dave Peterson