Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autocomplete is checked but doesn't work
In the Excel advanced options, Autocomplete is checked but when I start
typing a name that exists in the same column, Excel does NOT try to complete the name. What could be wrong? -- Cliver6 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autocomplete is checked but doesn't work
Do you have blank entries inbetween. Autocomplete works on continuous list;
there must be no blank rows between the list and your entry. Othere reasons http://support.microsoft.com/kb/211652 If this post helps click Yes --------------- Jacob Skaria "Cliver6" wrote: In the Excel advanced options, Autocomplete is checked but when I start typing a name that exists in the same column, Excel does NOT try to complete the name. What could be wrong? -- Cliver6 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autocomplete is checked but doesn't work
I should say continuous region rather than continuous list.
From the below entries in ColA and colB blank try Ctrl+down arrow in the blank cell. The available entries for autocomplete are displayed in the list. ColA a1 blank a2 a3 blank a4 Now to understand the "current region" try the same using additional entreis in colB ColA ColB a1 1 2 a2 3 a3 4 5 a4 6 If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Do you have blank entries inbetween. Autocomplete works on continuous list; there must be no blank rows between the list and your entry. Othere reasons http://support.microsoft.com/kb/211652 If this post helps click Yes --------------- Jacob Skaria "Cliver6" wrote: In the Excel advanced options, Autocomplete is checked but when I start typing a name that exists in the same column, Excel does NOT try to complete the name. What could be wrong? -- Cliver6 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter does not work on protected w/s even when "checked to allow" ?? | Excel Discussion (Misc queries) | |||
sum if box is checked | Excel Worksheet Functions | |||
sum if box is checked | Excel Worksheet Functions | |||
VBA Autocomplete | Excel Discussion (Misc queries) | |||
Can I insert a box on excel that can be checked and un-checked? | Excel Discussion (Misc queries) |