Forum Discussion
drop-down list
Hello, I want to create a drop-down list from another worksheet, I followed all the steps, but it seems that it does not include all the cells. Is there a limitation of number of cells? And is this fixable? Number of cells for drop-down list in data validation: 42082 number of cells
Thanks in advance,
A data validation drop-down list can contain at most 32767 items.
As an alternative, you could use two dependent drop-down lists - see Excel Dependent Drop Down Lists from Sorted Table with OFFSET
