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

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

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

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
he

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

BCW wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

Thanks,

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

Blanton

"Debra Dalgleish" wrote:

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
he

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

BCW wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html