Thread: drop down list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.