Data validation list limit?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a limit to the number of items that can appear in a data validation
drop-down? My source list can grow to be up to 1500 items long, and I don't
see any information in excel help or on this board about whether the
resulting data validation drop-down will be able to handle so many items.

TIA
 
Why bother with DV. The quick way is just type it in a cell instead of
looking through the long list of DV
 
Don't believe there is a limit.
I stopped at creating one to 11,000 items (rows) without any problem.
 
The range limit is 32,767 cells in a 1 dimensional array (single column or
row).

If you type in the items as a comma delimited array then the limit is ~255
characters.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation 1
Data Validation source = destination? 7
Data Validation Not Erroring with List 2
Data Validation List Names 2
Data Validation 4
Data Validation Lists 5
Validation list from Named Ranges 5
Created invoices in Excel - not working in Drive 1

Back
Top