Forum Discussion
Data Validation
Is there a limit to how many characters you can type into the Data validation source box having chosen List?
As Riny mentioned, it is best to enter the address of a range in the Source box.
If you enter the list directly into the Source box, the limit is 255 characters.