How to select a item by typing a letter or word in excel dropdown

By jitendrapatro ·
Suppose in drop down list there are 500 items are there and I want to select one item and I know the spelling of the word also then how can I select by typing the word. For example in Bank sites if you want to choose a branch then if you will type few letters of the place name then it is coming the suggested words. In the same manner I want so is there any option to do it.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums