Placement of cursor in drop dwn menu

  • Thread starter Thread starter Bruce B
  • Start date Start date
B

Bruce B

I have a wordbook with many worksheets in the sheets there are cells with
drop down lists. Problem is that slide bar is 1/2 way down so that when I
click on box to open I then have to hit up arrow to to get to top of list
How do I get bar to default to top of list when I open list
 
If you have any blanks in your source range, the Dropdown opens at first
blank.

Get rid of blanks in the list source range.


Gord Dibben MS Excel MVP
 
Not sure what to do with your answer. I have, as example, column with drop
down next two columns are set up with vlookup tables so that when data is
entered in list col next two columns automatically print desired info ( for
instance name address & phone number. I created a range so that list can grow
therefore right now there are lots of blank cells at bottom of list. I have
allocated for 1500 names and right now have 240

Thanks for assist
 
Instead of a Range like A1:A1500 with only the first 100 cells
filled............

Use a dynamic range for your source list then only those cells with data
will show in the dropdown. i.e. A1:A100 but will expand as more cells are
filled.

Instructions here at Debra Dalgleish's site.

http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord
 
Back
Top