Ask a Computer Question, Get an Answer ASAP!
Do you have a sample spreadsheet that you could attach here so I may see?
Yes I did, I have been trying out a few different potential solutions, sorry for the delay in getting back to you.
I would have thought autocomplete would have best suited your needs.
When you say combobox, what do you mean by it?
See the dropdown list that I have added to column B in the attached example - I think this is probably close to the best solution that you are going to get:
What about using a separate data validation list which is sorted alphabetically?
Unfortunately Excel is not advanced enough to function in the way that you want it to, to jump to a point in the dropdown using the first few letters typed.
I have assisted as best I can, given then limitations of Excel.