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