Max number of entries in drop down list?

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

Find more posts tagged with

Sheets

Healthcare

Cell linking

Comments

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!