How do i assure a pull down list begins at the top of the range?

[Guest]

I am using a range to validate and entry but the pull down always goes to the
bottom of the range. How do I get it to start at the top?

Thanks,

BCW

 

[Debra Dalgleish]

If the cell with the data validation list is blank, and there is a blank
cell at the end of the source range, that's what will be selected when
the list is opened.

You could use a dynamic range as the list source. There are instructions
here:

http://www.contextures.com/xlNames01.html

 

[Guest]

Thanks,

It might be time for me to take my skills to the next level. Thanks for your
link.

Blanton