THE DROPDOWNLIST OPENS WHERE YOU LEFT IT LAST TIME YOU USED IT , IN THIS
CASE YOU PROBABLY HAVE AN EMPTY CELL IN BETWEEN. TRY IT, LET ME KNOW.

"Karen" wrote:

I've created drop down lists using data validation and a silly but annoying
thing is that when I click a cell to drop down the list, the list scroll bar
is at the bottom. This is counter-intuitive--you would expect to find
yourself at the top of the alpha list, not at the bottom of it. So I find
myself scrolling to the top of the list (alpha order)...an extra step.

What am I missing?

TIA,

Karen