To make sure only the Validated list can be put in the drop down b

G

Guest

I have a validation criteria for a column which has a drop down menu. When i
enter the data other than the List , it gives me an error. But when i copy
and paste a cell from another excel sheet and i match the surce formatting it
will be entered in the cell which has a validation.
What am i to do ! Sholud i protect the cells
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation List (conditional) 2
Conditional Validation In Excel 1
Pick from drop-down list gives empty or erroneous result 6
data lookup/validation syntax 2
Drop Down List Format 2
Data Validation List problem 5
Data Validation Drop Down Using VBA? 1
changing validation drop down based on another cell value 5

Top