Max number of drop-down list elements in excel

J

Jin

Is there a max number of elements allowed in drop-down list in Excel? I was
using the data validation and entering the list in the "source" box (using ,
as delimiter), after I entered 34 elements, excel does not allow me to enter
more element to the drop down list.
 
J

Jin

Or I should ask "Is there a max number of chars in the source box?" Seems it
only allows ~250 charactors.
 
D

Dave Peterson

I think it's about 256 characters if you type them in the dialog box.

But if you just point to a range, you can have lots more. So can you add your
entries to a different worksheet (A1:Axxx), name that range, and even hide the
worksheet so that it's out of the way.
 
S

Shane Devenshire

Hi,

The answer is 32,767 items are the max. Use a range as suggested by Dave,
don't type the names into the Source box manually. It not only allows more
items, it also is more flexible to use a range.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 

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

Size of drop down in validation list 2
How to Link drop-down list? 2
To Link drop-down list 1
Filtered drop down list 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
How to edit the size of a drop-down list (using data validation)? 1
Excel Drop down 7
Customise drop down list validation 3

Top