Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
Hard to decide based on such sparse info, but probably your list source range contains empty cells at bottom. Then when dropdown is activated for empty cell, the (empty) bottom line of list is selected by default. Use a dynamic range as list source, to include only non-empty entries into list. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Corey" wrote in message ... I have some validation lists placed on some cells. But have noticed that due to the refernced cells being sometimes 10 cells long, they alway seem to open looking at the last few cells. Is there a way to have the list scrolled to the top when clicking the cell? -- Regards Corey |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
validation list | Excel Worksheet Functions | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Dependent List (via Data Validation) Error | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |