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.

1] Enter Data Validation Details Open the Microsoft Excel file, select the cells you would like to limit. Go to the ‘ Data ’ tab located on the Ribbon menu.

When you update this spreadsheet with new or different data, you won’t have to re-create the validation rule, but you will need to click Circle Invalid Data again. This tool would be useful to bring ...

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.

Microsoft Excel’s Data Validation feature provides an easy way to create a dropdown at the sheet level. If you base the list on data, you’ll probably want a list of unique items, which is ...

Excel's checkboxes seem like a very simple feature on the surface—which is probably why they're often overlooked. But when used properly, this underrated feature can transform your spreadsheets into ...