In excel can you start typing and have excel pull up a list to choose from?

If I create a drop down list for a column in excel can you set the list so that when a person starts to key in a word it will start listing the selections at the letters you key in.
BenbaseballerAsked:
Who is Participating?
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
Well, actually yes there is but a bit cumbersome if you have very long lists for your dropdown.

When you have a list of entries if you start typing another entry below that list Excel will give the option of AutoFill based on values above.

Therefore, to accommodate this with your Dropdown you can put your complete dropdown list at the top of the column in which it is going to be used and then hide or Group and collapse.

See attached. In column D I have put a dropdown for Day of the week. In the hidden rows above there is Sunday through Saturday and the dropdown refers to this list. If you start typing in the next empty cell in column D, the autofill will populate when it recognises the start of the entry. The Autofill will only give a suggestion once there is only one option so typing "T" won't give Tuesday and Thursday but typing "Tu" will then show Tuesday.

Thanks
Rob H
Autofill-Dropdown.xlsx
0
 
Martin LissOlder than dirtCommented:
You can if you "float" a combobox as explained in this article of mine.
0
 
BenbaseballerAuthor Commented:
So there is nothing in excel itself that allows you do this?
0
 
Martin LissOlder than dirtCommented:
As far as I know, no.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.