- Mar 19, 2002
I must be missing something here. I set up Data Validation with a drop down list. (If it makes any difference the list is on a separate sheet.) The drop down list works fine, I can pick any item from the list to populate the cell. My problem is that if I click on the cell and start typing it allows me to put anything I want in the cell, regardless of whether it's in my list. What am I doing wrong?