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
|