| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list Q
My drop down list, when opened for selection, always displays the last half
dozen entries, therefore I have to scroll up to find the one I want, rather than scrolling down. Why would this be? -- Traa Dy Liooar Jock |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list Q
It sounds like your Data Validation is based on a list that includes blank
cells at the bottom. Since the DV cell is already blank, it's matching the 1st blank cell in the source range. You should either base the list on the actual list items (with no blanks) OR base the DV on a Dynamic Range Name....which automatically expands and contracts to accommodate the data. Debra Dalgleish has Dynamic Range Name instructions at her website: http://www.contextures.com/xlNames01.html#Dynamic Am I on the right track? -- Try something like this: From the Excel main menu: <<< Is that something you can work with? Does that help? *********** Regards, Ron XL2003, WinXP "Jock" wrote: My drop down list, when opened for selection, always displays the last half dozen entries, therefore I have to scroll up to find the one I want, rather than scrolling down. Why would this be? -- Traa Dy Liooar Jock |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list Q
Absolutely on the right track. There is a blank cell at the bottom of my list.
Thanks Ron -- Traa Dy Liooar Jock "Ron Coderre" wrote: It sounds like your Data Validation is based on a list that includes blank cells at the bottom. Since the DV cell is already blank, it's matching the 1st blank cell in the source range. You should either base the list on the actual list items (with no blanks) OR base the DV on a Dynamic Range Name....which automatically expands and contracts to accommodate the data. Debra Dalgleish has Dynamic Range Name instructions at her website: http://www.contextures.com/xlNames01.html#Dynamic Am I on the right track? -- Try something like this: From the Excel main menu: <<< Is that something you can work with? Does that help? *********** Regards, Ron XL2003, WinXP "Jock" wrote: My drop down list, when opened for selection, always displays the last half dozen entries, therefore I have to scroll up to find the one I want, rather than scrolling down. Why would this be? -- Traa Dy Liooar Jock |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list Q
OK, how can I automatically extend the drop down list to show all options and
lose the scroll bar? Thanks, -- Traa Dy Liooar Jock "Jock" wrote: My drop down list, when opened for selection, always displays the last half dozen entries, therefore I have to scroll up to find the one I want, rather than scrolling down. Why would this be? -- Traa Dy Liooar Jock |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list Q
See this website for instructions:
http://www.contextures.com/xlDataVal10.html Does that help? *********** Regards, Ron XL2003, WinXP "Jock" wrote: OK, how can I automatically extend the drop down list to show all options and lose the scroll bar? Thanks, -- Traa Dy Liooar Jock "Jock" wrote: My drop down list, when opened for selection, always displays the last half dozen entries, therefore I have to scroll up to find the one I want, rather than scrolling down. Why would this be? -- Traa Dy Liooar Jock |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list Q
Thanks Ron.
-- Traa Dy Liooar Jock "Ron Coderre" wrote: See this website for instructions: http://www.contextures.com/xlDataVal10.html Does that help? *********** Regards, Ron XL2003, WinXP "Jock" wrote: OK, how can I automatically extend the drop down list to show all options and lose the scroll bar? Thanks, -- Traa Dy Liooar Jock "Jock" wrote: My drop down list, when opened for selection, always displays the last half dozen entries, therefore I have to scroll up to find the one I want, rather than scrolling down. Why would this be? -- Traa Dy Liooar Jock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a drop-down list along with an auto-populate drop-down | Excel Discussion (Misc queries) | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| Can I create a drop-down list that will reference other drop-down | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Hybrid Mode
