Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |