Automatic data entry problem in EXCEL 2003

  • Thread starter Thread starter TONY
  • Start date Start date
T

TONY

I set up a list to automatically plug in city names when i typed the first
few letter. However, now it does it for every sheet, new or old and I don't
need it to. I can't remember the name of the function and have scoured help
(local and on-line) trying to find the feature - no luck. Can anyone tell me
the name and how to turn it off for other worksheets.

Many thanks,
 
It's called autocomplete.

In xl2003 menus:
Tools|Options|Edit Tab|Uncheck "Enable Autocomplete for cell values"
 
Back
Top