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

Drop Down with dynamic named range offsheet source list 14
Dependent drop down dynamic range formula, off sheet. 7
Formatted cell column in drop down list 1
drop down lists 1
Drop Down LIsts 2
Excel Lists 4
Drop Down Lists 2007 10
Data Validation Lists 5

Top