Question Locked

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

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

2 replies

by john.a.wills

ALT/Edit Find will bring up a little window in the lower left: type in what you know and then enter. But no suggestions come up, and I don't think Excel has such a facility.

This discussion is closed to new replies.