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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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,214,646
Messages
6,120,720
Members
448,986
Latest member
andreguerra

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