For a data validation list, the default display length appears to be 8 lines.
If I am using a dynamic data range that is longer than 8, the dropdown list
displays the values at the end of the range. I have read various articles on
size and display of a dropdown list but have not found any reference to
this. Is there a way to format the data validation so that the drop down
list starts at the top of the range, or do I need to use a static range?
Thank you.