Why Excel Is Showing This Error When I Try to Do Data Validation
I Am Trying to Do Data Validation in Excel and I've Done It Before but for Some Reason Now This Error Is Showing Up. This Is the Error Image Here Is the Source...
I am trying to do data validation in Excel and I've done it before but for some reason now this error is showing up. This is the error image
Here is the source table for it Source table
How can I fix this?
2 Answers
When using "Lists" for data validation in excel spreadsheets, you must specify a range either horizontal (A1:J1) or vertical (A1:A10). This means you are not will be able to specify a "Matrix range" (A1:J10), and that is why the warning message says: "The list must refer to a single row or column (no a matrix).
Example of a wrong range selection: Example of a wrong range selection
Example of a correct range selection: Example of a correct range selection
It means that the data validation list must be a one-way list (single column range or single row range), or a delimited list like this: A, B, AB, CD.
Range("A1:A10") Valid
Range("A1:D1") Valid
Hope it's helpful
Range("A1:C10") Invalid
Sarah Jenkins is a veteran tech journalist with over 12 years of experience covering artificial intelligence, mobile innovations, and digital ethics. Her insights have appeared in leading technology publications worldwide.
