Thanks to you both for your assistance. I followed the instructions for
creating a dynamic list but it didn't work because the list is actually a
part of a pre-defined array. Excel recognizes all of the rows in the array
as being a part of the list.

Also, the problem is not the blank row really. While I would prefer not to
have the blank row I wouldn't really care if it appeared at the bottom of the
list, as long as the dropdown list opened up at the top of the list, which is
all I'm trying to do. I don't understand why my list is behaving this way.

Any other suggestions???
Thanks again,
Steve

"Ragdyer" wrote:

Are you using Data Validation for this drop down?

Just eliminate the blank cell from the end of the list.

If you *want* a blank cell in the list to enable user input beyond the list,
make the *first* cell in the list blank.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"stebro" wrote in message
...
Excel 2003; I have a dropdown box populated from a list of about 100
items.
When the user selects the dropdown box to choose an item I want the first
row
in
the list to be displayed on top (with the scroll bar all the way at the
top); currently the last row is displayed (and it's blank).

I cannot figure out why this is happening or what to do about it.

Thanks,
Steve