drop down list
 

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.

drop down list
 

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


"Linda" wrote in message
...
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.

drop down list
 

Thank you. Found the empty cell and removed it.

"T. Valko" wrote:

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


"Linda" wrote in message
...
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.


.

drop down list
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Linda" wrote in message
...
Thank you. Found the empty cell and removed it.

"T. Valko" wrote:

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


"Linda" wrote in message
...
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.


.