Drop-down list from Data Validation List keeps moving to the bottom, any way to make it stay on the top?

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?
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
I figured it out myself. By adding an extra (blank) row at the top of my source column, the first blank cell that Excel finds is at the top, thus it will always start at the top of the drop-down list!
 
Upvote 0

Forum statistics

Threads
1,216,099
Messages
6,128,822
Members
449,469
Latest member
Kingwi11y

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top