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?