Bhiravi

From the helpfile on "AutoComplete": Turn on or off automatically
completing entries in columns On the Tools menu, click Options, and then
click the Edit tab.

To allow automatic completion, select the Enable AutoComplete for cell
values check box.
To prevent automatic completion, clear the check box.

Hope this helps

Mike Rogers


"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?