How do I get a drop down list to always go to the top of the list

[Dawn]

Hi, I am using a drop down list and when I click on the arrow it always goes
to the bottom of the list and you always have to move it up to the top. is
there a way that when you click on the arrow it always goes to the top of the
list?

 

[Duke Carey]

Go to this site and look in the index under Data Validation. Debra Dalgliesh
has pretty thoroughly documented what you can & cannot do with drop downs

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