Excel has a "sort of" autocomplete feature.
It looks at cells above/below it to attempt an autocomplete. It doesn't
check many though. Certainly not the 1000s you're talking about.
I wrote the word test into cell a1 then wrote the word excel into cells
a2:a1000
typing the first few characters of "test" started autocomplete, with
different behaviours depending on how far away you we

typing t autocompleted on A51, but didn't on A52, I had to type te to get it
to autocomplete.
getting autocomplete to start became more difficult after 50 cells
clearance.

I don't know of a another simple way to autocomplete.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"G Lam" wrote in message
...
Hi, I have a vlookup cell to look up a list of 5500 items. Some times,
users
may enter a wrong item and got nothing retunred. I am thinking of add a
drop
down box for them to lookup the list in that case. However, 5.5K item is
way
too much for the drop down. Does Excel have a function like Access that
when
user enter first few characters, the drop down will show a list of items
have the same characters. How can I code that?
Thank you.
GL