View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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