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?

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?