Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
? sort data in a drop down box w/ initial cell entry
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
? sort data in a drop down box w/ initial cell entry
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 Leef wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying data from seperate sheet upon drop down box entry | Excel Worksheet Functions | |||
Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
Lock Cell After Data Entry | Excel Discussion (Misc queries) | |||
Cell data format | Excel Discussion (Misc queries) | |||
Add data to cell w/o loosing initial data | Excel Discussion (Misc queries) |