drop down list

[Linda]

When prompted to select from the drop down list, it starts at the very
bottom. You then have to scroll up to get to the top of the list. How do I
change this so that the list starts at the top instead of the very bottom?
Using Excel 2003.

 

[T. Valko]

The list will automatically goto the selection that matches the cell entry.
It sounds like you probably have an empty cell in your source list. So,
you'd have to remove (exclude) that empty cell from the source.

Are you using a dynamic range as the source? If so, check and make sure it's
calculating the correct range.

 

[Linda]

Thank you. Found the empty cell and removed it.

The list will automatically goto the selection that matches the cell entry.
It sounds like you probably have an empty cell in your source list. So,
you'd have to remove (exclude) that empty cell from the source.

Are you using a dynamic range as the source? If so, check and make sure it's
calculating the correct range.

--
Biff
Microsoft Excel MVP





.

 

[T. Valko]

You're welcome. Thanks for the feedback!