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.

On the Data Validation dialog, choose the criteria you want to use in the boxes on the Settings tab. Go to the Input Message tab and enter the message you want users to see when they click in the ...

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.