disallow

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...

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...

say it wasn't fair? But when it happens to the U.S it is part of the game?