Menu
Does anyone know how many options a drop down list can have? Is it unlimited? How many before performance degrades?
668
When you create a drop-down list, you can only make one selection. If you select another item, the first one is replaced with the new selection.
If you enter the names in a range on a worksheet, and set the Source of the Data Validation to that range, the list can contain up to 32767 items.
It is not possible to limit the number of visible elements in the select dropdown (if you use it as dropdown box and not as list). But you could use javascript/jQuery to replace this selectbox with something else, which just looks like a dropdown box. Then you can handle the height of dropdown as you want.
To select multiple options in a drop-down list, use the multiple properties. It allows you to select more than one option while pressing CTRL key.
Does anyone know how many options a drop down list can have? Is it unlimited?
I imagine it is unlimited in theory, obviously not in practice as a computer's RAM and the specific browser's limitations come into play.
How many before performance degrades?
Again, this would depend on a few factors, at the least the specific browser, the computer's memory and processing power.
EDIT: From experience, I have had drop down lists with thousands of options. It wasn't ideal though because who wants to scroll through all of those? This is why an auto-complete of some type is more desirable for numerous reasons, especially the end user's experience.
60
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
