List the Drop down list from the top

  • Thread starter Thread starter forest8
  • Start date Start date
F

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
 
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?
 
Yes there are blanks.


T. Valko said:
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?
Click to expand...
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drop down list 3
drop down list 2
Position of a drop-down list 5
Simple Question?? 2
Filtered drop down list 2
Excel Excel: How do I put a formula in a drop down list 11
Drop-Down List 3
Data Validation drop-down 5

Back
Top