Starting drop down lists at the top

  • Thread starter Thread starter test123
  • Start date Start date
T

test123

I have several drop down lists on sheet 1 where the data sets are o
sheet 2. Some of my drop down lists start at the first entry and other
start at the middle of the list. How can I get all my drop downs t
start at the beginning of the list when the drop down is clicked?
Thanks for your help
 
hi, !
I have several drop down lists on sheet 1 where the data sets are on sheet 2.
Some of my drop down lists start at the first entry and others start at the middle of the list.
How can I get all my drop downs tostart at the beginning of the list when the drop down is clicked?
Click to expand...

it seems that your named-range (sheet 2) includes blank cells in the middle-way (?)

hth,
hector.
 
Back
Top