NewbieNoob
New Member
- Joined
- Feb 23, 2018
- Messages
- 15
I have a data validation list for every cell in a column.
The source for the data validation is dynamic, so that whenever you choose one parameter from the validation list, it gets removed from the source list.
Because of this, when I go to a second cell and click on the drop-down menu, it starts at the bottom of the list. Is there any way I can force Excel to start the drop-down list at the top on every cell?
The source for the data validation is dynamic, so that whenever you choose one parameter from the validation list, it gets removed from the source list.
Because of this, when I go to a second cell and click on the drop-down menu, it starts at the bottom of the list. Is there any way I can force Excel to start the drop-down list at the top on every cell?