Melissa uses Data Validation regularly to limit what can be put into a cell.She notes that one flaw seems to be that it's always possible to overwrite the data by copying a cell from somewhere else in the file and pasting it into the cell that should be limited by Data Validation.In this example, we restrict users to enter a whole number between 0 and 10. To create the data validation rule, execute the following steps.
Throughout this article, we'll work with the table object.
You can hide the temporary value by just changing the color to white.
Excel's data validation feature lets you embed a drop-down list into a sheet.
Melissa wonders if there is any way to "lock down" the cells that have Data Validation, so no one can paste over them.
Melissa has discovered what some have called the "Achilles' heel" of Data Validation—you can paste over cell contents and thereby destroy whatever Data Validation rules were in the target cells.