Predictive text?

[Guest]

You can create a lookup table through Data, Validation, List. But can you do
a similar thing where the lookup list is sorted depending on what you type
in? eg: If you start to type "peter" the list shortens to items begining with
p when you type "p" and then shortens to items begining with pe when you type
"pe" etc.
Many thanks
Peter

 

[Jason Morin]

Excel will auto complete the word if that same word
already exists directly above or below the validation
cell in the same column. I would move the source list for
the validation cell directly above it, then hide those
cells (rows really).

HTH
Jason
Atlanta, GA