| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list
I have created a drop down list. Is there any way to start typing a letter
in the cell and the corresponding choices appear, instead of scrolling down the list? If so, is it possible to have both the scroll option and the type a letter option, not just one or the other? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down list
See example:
-You type first letter -Click on drop down list http://boisgontierjacques.free.fr/fi...stLetters..xls =Offset(Noms,Match(A2&"*",Noms,0)-1,,Countif(Noms,A2&"*")) JB http://boisgontierjacques.free.fr On 23 avr, 17:37, Rita wrote: I have created a drop down list. *Is there any way to start typing a letter in the cell and the corresponding choices appear, instead of scrolling down the list? * If so, is it possible to have both the scroll option and the type a letter option, not just one or the other? * Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
