Is the data validation criteria limited to a few number of items .

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

Guest

I would like to have several list in a particular cell. However, I have found
that Excel is limited to the number of items that can go in a list. Why?

Or how can I list a choice of 30 or more items in one cell?
 
Rhonda

I just put 3000+ numbers in a list and selected it as the validation source.
No problem.

What does your data look like ?

Regards

Trevor
 
The date are words. IE... Loans, Home Equity, Personal Unsecured .....
 
Rhonda

I can't see why it should be a problem if you do as Debra described. That's
the way I tested using just numbers

Regards

Trevor
 
You must log in or register to reply here.

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 list limit? 3
XL2000 - Data Validation Lists 1
Multiple data validation criteria? 1
Validation List 2
Validation list from Named Ranges 5
Maximum number of data validation cells? 3
Data Validation List Names 2
resettable, over-ridable, default cell values 0

Back
Top