I've created a list of drop down values for each cell in a column so that one can only choose from the drop downs. However when i copy info from another cell (where no validation has been performed) and paste into the cell with drop downs, excel allows it. Is there any way one can restrict the user to only choose from the list and not allow the user to copy and paste info?