Hello,
I thought this would be straightforward or already answered somewhere on the web, but I couldn't get a clear answer.
My impression was that defining a dropdown menu list for cell data validation would restrict cell entries only to items from that menu. But to my surprise I found out today that in addition to those dropdown items, I could type in anything else that I wanted to . (My dropdown menu is designed so well that it gives the students the options from 1,2,3, and 4 and every time one of these are selected, the remaining cells don't show that number, so if 1 is selected, then only 2,3,4, remain for the subsequent cells.) But one of my students showed me today that not only numbers from 1 to 4, but anything else (even letters etc.) can also be typed in there as if the data validation dropdown wasn't even there.
Any ideas why this is the case? Am I missing anything ? Any solutions?
Please direct me to any posts address this if available.
(P.S. I can define conditional formatting to highlight cells that get anything besides 1,2,3, or 4, but still it doesn't make sense that the dropdown doesn't take care of the situation by itself)
I thought this would be straightforward or already answered somewhere on the web, but I couldn't get a clear answer.
My impression was that defining a dropdown menu list for cell data validation would restrict cell entries only to items from that menu. But to my surprise I found out today that in addition to those dropdown items, I could type in anything else that I wanted to . (My dropdown menu is designed so well that it gives the students the options from 1,2,3, and 4 and every time one of these are selected, the remaining cells don't show that number, so if 1 is selected, then only 2,3,4, remain for the subsequent cells.) But one of my students showed me today that not only numbers from 1 to 4, but anything else (even letters etc.) can also be typed in there as if the data validation dropdown wasn't even there.
Any ideas why this is the case? Am I missing anything ? Any solutions?
Please direct me to any posts address this if available.
(P.S. I can define conditional formatting to highlight cells that get anything besides 1,2,3, or 4, but still it doesn't make sense that the dropdown doesn't take care of the situation by itself)
Last edited: