Automatic data entry problem in EXCEL 2003
It's called autocomplete.
In xl2003 menus:
Tools|Options|Edit Tab|Uncheck "Enable Autocomplete for cell values"
TONY wrote:
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,
--
TONY
--
Dave Peterson
|