Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down list in Excel
I set up a drop down list in excel and wanted to know if there was a way to
set up a predictive text feature so that i don't have to scroll through the entire list to select the correct entry. i would like to be able to type in the first two letters and have the entry appear. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down list in Excel
If you use the datavalidation it is not built in, you need a combobox from
the control toolbox -- Regards, Peo Sjoblom (No private emails please) "B9" wrote in message ... I set up a drop down list in excel and wanted to know if there was a way to set up a predictive text feature so that i don't have to scroll through the entire list to select the correct entry. i would like to be able to type in the first two letters and have the entry appear. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down list in Excel
As Peo said, if you created the dropdown lists by using data validation,
it doesn't support autocomplete. If you can use programming, there are instructions here for adding a combobox from which you can select one of the values from the data validation list. In the combobox, you can enable autocomplete: http://www.contextures.com/xlDataVal11.html B9 wrote: I set up a drop down list in excel and wanted to know if there was a way to set up a predictive text feature so that i don't have to scroll through the entire list to select the correct entry. i would like to be able to type in the first two letters and have the entry appear. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I choose from the drop down list in excel | Excel Discussion (Misc queries) | |||
How do I make a drop down list to pick from for a cell in Excel | Excel Discussion (Misc queries) | |||
Update Excel Data List for Drop Down use | Excel Discussion (Misc queries) | |||
How do I increase type size in an Excel drop down list? | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |