? sort data in a drop down box w/ initial cell entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a dorp down box w/ numeric data sorting in ascending order. Can I
enter a number in the cell, ie: '6' and then hit the drop arrow to have the
data sort to numbers starting with '6' as opposed to always starting at the
top of the data list and having to scroll down to the data of choice
 
If the dropdown list is from 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
 
Back
Top