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 this example, that would be E2:E51. Go to Data on the Ribbon, and in the Data Tools group, choose Data Validation. The Data Validation window that pops up allows you to set your criteria in many ...

Figure A We’ll add a data validation control to this sheet. Click the Data tab, and then, click Data Validation in the Data Tools group. In the resulting dialog, choose List from the Allow dropdown.