Dropdown list doesn't display from the top of the list

[Guest]

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

 

[Gord Dibben]

If using Data Validation List, re-define the range to get rid of the blanks at
bottom of the list.

Maybe a dynamic range would be better.

See Debra Dalgleish's site for this.

http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord Dibben MS Excel MVP

 

[Ragdyer]

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.

 

[Guest]

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

 

[Gord Dibben]

When you first create the DV dropdown list cell the cell value is blank.

The list will default to the first blank cell at the bottom of the list because
that is the value in the newly created DV cell.

After you have selected any item other than the blank, that item will become the
dropdown default when you click on arrow next time.


Gord