Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List the Drop down list from the top
Hi
I hope this makes sense. Currently I have multiple drop down lists. Every time I access a drop down list, the list is at the bottom instead of at the top. How do I make it so that it lists from the top down instead of the bottom up? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
List the Drop down list from the top
The list automatically scrolls to the selection that matches the cell entry.
Do you have an empty cell at the end of the list source? -- Biff Microsoft Excel MVP "forest8" wrote in message ... Hi I hope this makes sense. Currently I have multiple drop down lists. Every time I access a drop down list, the list is at the bottom instead of at the top. How do I make it so that it lists from the top down instead of the bottom up? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
List the Drop down list from the top
Yes there are blanks.
"T. Valko" wrote: The list automatically scrolls to the selection that matches the cell entry. Do you have an empty cell at the end of the list source? -- Biff Microsoft Excel MVP "forest8" wrote in message ... Hi I hope this makes sense. Currently I have multiple drop down lists. Every time I access a drop down list, the list is at the bottom instead of at the top. How do I make it so that it lists from the top down instead of the bottom up? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
List the Drop down list from the top
OK, then you either have to remove the blanks from the source or you have to
use a dynamic range that refers to the list source without any blanks at the bottom of the range. -- Biff Microsoft Excel MVP "forest8" wrote in message ... Yes there are blanks. "T. Valko" wrote: The list automatically scrolls to the selection that matches the cell entry. Do you have an empty cell at the end of the list source? -- Biff Microsoft Excel MVP "forest8" wrote in message ... Hi I hope this makes sense. Currently I have multiple drop down lists. Every time I access a drop down list, the list is at the bottom instead of at the top. How do I make it so that it lists from the top down instead of the bottom up? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
drop down list shows first blank row after last list entry | Excel Discussion (Misc queries) | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
Drop-down list Populated by a Subset of a larger 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) |