Data Validation items limit

V

Vinod

Hi All,

Is there any limit for number of items to place in data validation list?
Since I tried with 90 items to assign in datavalidation list but I couldn't.

Please share your thought or ideas.

Advanced Thanks,
Vinod
 
J

John C

I just created a DV List with 10,000 items with no difficulty. Perhaps more
information on your setup is necessary.
 
D

Debra Dalgleish

If you create a delimited list, by typing the entries in the Data
Validation dialog box, the limit is 255 characters.

If you need a longer list, you could enter the items on a worksheet,
name the range, then refer to that named range. There are instructions here:

http://www.contextures.com/xlDataVal01.html
 

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

Validation list font change 1
Valist list font color 1
Offset Named range in Datavalidation List 4
Validation list with array formulaes 6
Validate if cell use data validation 2
Using Table Column for Data Validation List 2
Data Validation 3
pick multiple items in data validation 2

Top