is there limit for list in data validation?

%3CLINGO-SUB%20id%3D%22lingo-sub-1796114%22%20slang%3D%22en-US%22%3Eis%20there%20limit%20for%20list%20in%20data%20validation%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1796114%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20add%20a%20category%20to%20my%20data%20validation%20drop%20down%20menu%20but%20it%20is%20not%20allowing%20me%20to.%26nbsp%3B%20it%20allows%20me%20to%20add%20a%20comma%20and%20first%20letter%20and%20then%20nothing%20else%3F%3F%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1796114%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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

@heinseyc 

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

@heinseyc 

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

 

 

Nikolino

 

I know I don't know anything (Socrates)