Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If there's a blank cell in the source list, and the cell with the data
validation list is blank, the list will open with the blank entry selected. To prevent this, either enter a default value in the data validation cell, or remove the blanks from the source list. dread wrote: I have a data validation list and when I click on the drop down arrow to display it the list is displayed starting at the bottom of the list instead of the top of the list. Does anyone know why this is and how to fix it??? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation list sort order | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
How to force a Default sort for a validation list | Excel Discussion (Misc queries) | |||
I want to sort everything but my validation list | Excel Worksheet Functions |