Question

Locked

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.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

not exactly what you are asking for

by john.a.wills In reply to How to select a item by t ...

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.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums