Data validation restricts what can be entered in a cell: value type, numeric range, text length, list of choices or custom rule. It prevents entry errors and label inconsistencies that skew calculations. It can display a help or error message and does not prevent pasting values.
Example
Allow only whole numbers between 1 and 100 in cell B2.