If your list is Contiguous (no blanks) then AutoComplete will kick in.


--
Regards
Dave Hawley
www.ozgrid.com
"TQ" wrote in message
...
Hi, I would like to key in data which duplicate before, I notice that some
will be auto complete but some not, I already check the autocomplete
function
in Tools.

Anyone who know the reson and can provide solutions ? All my data start wz
"
- " i.e - Willam or - Robert & etc.

Thanks.