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 f...
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