Data Validation lists display bottom vs top

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

OK.

I learned a ton of stuff from Debra Dalgleish's site about data validation
with dynamic lists and now I'm down to the silly stuff.

When I enter a cell that has data validation via one of these lists the list
always displays the bottom of the list instead of the top of the list. Is
there a way to have the scroll bar start at the top all the time. Not a big
deal but my users aren't particularly observant and I'm afraid they'll think
that the choice that they want isn't on the list (instead of scrollling the
list up).

Appreciate the help.
 
Usual cause of this is you have at least one blank cell at the bottom of your
list range.

Get rid of it/them.


Gord Dibben MS Excel MVP
 

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

Adding to a data validation list 2
Validation Dropdown list starts at b ottom of list 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
data validation 7
Position of a drop-down list 5
List the Drop down list from the top 3
Data Validation drop-down 5
drop down list 3

Back
Top