Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation list order
my data validation list sometimes starts at the bottom vs top of list how do
I set that it always starts at top of list? does a way exist that user can start to type item in list and it will find it and populate. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation list order
No, you would need a combo box from the control toolbox toolbar
-- Regards, Peo Sjoblom "PCreighton" wrote in message ... my data validation list sometimes starts at the bottom vs top of list how do I set that it always starts at top of list? does a way exist that user can start to type item in list and it will find it and populate. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation list order
The usual reason the DV list starts at the bottom of the list is that the
referenced range has blank cells at the bottom of it. When you first click the dropdown button, the list defaults to the current selection. If the current cell is blank, the DV list defaults to the first blank cell in that list. If there ARE blank cells and they are only there to allow for list expansion, it would be better to base the list on a Dynamic Range Name (which will expand/collapse to accommodate the data). See Debra Dalgleish's website for instructions: http://www.contextures.com/xlNames01.html#Dynamic Regarding autocomplete in DV lists....not a feature of them. However, if you must have that kind of feature, again, see Debra Dalgleish's website for instructions: http://www.contextures.com/xlDataVal10.html Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "PCreighton" wrote in message ... my data validation list sometimes starts at the bottom vs top of list how do I set that it always starts at top of list? does a way exist that user can start to type item in list and it will find it and populate. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VALIDATION LIST ORDER | Excel Worksheet Functions | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions |