(Of course, I can't reproduce this behavior NOW when I want to test it!!)
When you select the cells from which to validate, select only populated
cells. This is one of my pet peeves about data validation. The other thing
you could do, which is what I do: Make your first selection something like
"Pick one". Then conditionally format the cell so that if it contains "pick
one", it's got a yellow background. This way you can choose the "pick one"
and leave it chosen as the default status, and also emphasize what still
needs to be done by the user.
************
Anne Troy
www.OfficeArticles.com

"Smith@ Clark" <Smith@ wrote in message
...
I have set up various lists in a spreadsheet. When I click on the drop
down, I start at the bottom, where it is blank, rather than at the top of
the
list. How do I make the drop down begin at the top of the list?

Thanks