Hi Excel Forum,
I am working at a new job and have moved over to Mac, and further, EXCEL ON MAC!
I created some simple drop down menus with data validation and am finding that I CAN MANUALLY CHANGE THE CELLS with these drop down lists.
My input message and error alerts are completely set up. And the cell is not supposed to take any other data than what is obviously in my drop down list.
I have no idea why it would let me manually change the data in these cells. Does anyone else have an idea of how I can fix this?
BTW I'm working on Excel for Mac 2011 Version 14.3.2.
Please let me know if you have any ideas!
Thank you!!!
Crissy
Bookmarks