| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic data entry problem in EXCEL 2003
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data entry Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I make tab automatic in an excel data entry form? | New Users to Excel | |||
| Automatic Data Entry | Excel Discussion (Misc queries) | |||
| excel automatic data entry | Excel Discussion (Misc queries) | |||
| Automatic data entry | Excel Discussion (Misc queries) | |||
Linear Mode
