Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clearing the autocomplete list in a cell
Oh Wise Ones,
I have stumbled upon this before but I cannot remember how I did it. I would like to clear the list that excel uses to complete a cell editing when you start typing. If someone could steer me in the right direction, it would be most appreciated. Thanks, Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clearing the autocomplete list in a cell
There isn't a list to clear it uses the cells above the one you are typing in
and as soon as there is no ambiguity Excel offers an auto-complete option. All you can do is trun it off with:- Tools|Options|Edit Mike "Mike K" wrote: Oh Wise Ones, I have stumbled upon this before but I cannot remember how I did it. I would like to clear the list that excel uses to complete a cell editing when you start typing. If someone could steer me in the right direction, it would be most appreciated. Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoComplete list should accept ENTER key as well as TAB | Excel Discussion (Misc queries) | |||
Validation List Autocomplete | Excel Discussion (Misc queries) | |||
Autocomplete from a list on the worksheet | Excel Worksheet Functions | |||
Clearing List Boxes | Excel Discussion (Misc queries) | |||
autocomplete from a drop down list | Excel Discussion (Misc queries) |