Max number of entries in drop down list?

Andrew Miller

Hi;

Is there a limit to the number of entries in a drop down list?  Would  a list of 1200-1500 names have an impact on performance?  We don't need validation or conditional formatting (e.g. red for a value is entered that is not in the list). Are there best practices for a task like this?

Thanks in advance,

Andrew

Kara Lumley

Hi Andrew,

The drop down list can hold up to 5,000 entries. With so many entries, I would consider logically sorting the entries, you can also create separators as well, like this:

 

Andrew Miller

Thanks for answering my question and providing a tip!