Data Validation in Microsoft Excel allows users to control the type of data entered into the worksheet. It picks from a list of rules to limit the type of data that can be entered into a cell.

In the Data Validation dialog box, you can choose from various settings and rules to apply to your data. Data validation is a feature that restricts the type, range, or format of data entered into ...