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

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?

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

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


"Dawn" wrote:

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?