Autocomplete is checked but doesn't work

  • Thread starter Thread starter Cliver6
  • Start date Start date
C

Cliver6

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?
 
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
 
Back
Top