thenrich
asked on
Excel Data validation - List
I have a list set up for the user to select from and have selected entire column as the range. The problem I have is when the user goes to cell to select the scroll bar is in the middle of the dropdown list vs the top.
How can I force the scroll to the top without having to select the specific range of cells? I need to leave it the entire column in case more data is added.
Thank you.
How can I force the scroll to the top without having to select the specific range of cells? I need to leave it the entire column in case more data is added.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Actually figured this out about 30 sec after I posted the question. This is exactly what I did.
Make the list on Sheet2, column A, with a header, and type the values from A2 down.
No blanks allowed in between.
Create a named range List1, with a “Refers to” property of:
=Sheet2!$A$2:INDEX(Sheet2!
In the Datavalidation use list reference to =List1
By using a named range, the list can be on another sheet.
See file.
Datavalidation-no-blanks.xlsx