List the Drop down list from the top

[forest8]

Hi

I hope this makes sense.

Currently I have multiple drop down lists. Every time I access a drop down
list, the list is at the bottom instead of at the top.

How do I make it so that it lists from the top down instead of the bottom up?

Thanks

 

[T. Valko]

The list automatically scrolls to the selection that matches the cell entry.

Do you have an empty cell at the end of the list source?

 

[forest8]

Yes there are blanks.

The list automatically scrolls to the selection that matches the cell entry.

Do you have an empty cell at the end of the list source?

 

[T. Valko]

OK, then you either have to remove the blanks from the source or you have to
use a dynamic range that refers to the list source without any blanks at the
bottom of the range.