Drop down list Q

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
OK, how can I automatically extend the drop down list to show all options and
lose the scroll bar?
Thanks,
 
Back
Top