Excel Data validation - List
Posted on 2014-02-28
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.