Starting drop down lists at the top

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
 
H

Héctor Miguel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down lists in seperate columns 5
Drop down list control value in vba 2
Paragraph numbering in Word 1
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Formatted cell column in drop down list 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Limit drop down items based on another cell 3

Top