is there limit for list in data validation?

Occasional Visitor

I am trying to add a category to my data validation drop down menu but it is not allowing me to.  it allows me to add a comma and first letter and then nothing else?????

2 Replies


Do you mean size of the list; or select as you type; or something else? And for which Excel.


With your permission, if I can recommend you, add a file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.


* Knowing the Excel version and operating system would also be an advantage.


Thank you for your understanding and patience





I know I don't know anything (Socrates)