Go to the ‘ Data ’ tab located on the Ribbon menu. Under the ‘ Data Tools ’ select ‘ Data Validation ’ option. When the Data Validation window opens, you’ll see several controls.

The Data Validation window that pops up allows you to set your criteria in many ways. For our example, choose Whole Number for Allow:, greater than or equal to for Data:, and -700 for Minimum:.

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.

Validation is an automatic computer check to ensure that the data entered is sensible and reasonable. It does not check the accuracy of data. For example, a secondary school student is likely to ...

Discover how a custom data validation tool is transforming education. Learn how we applied statistics to achieve fairness in peer reviews. See how we successfully scaled the "Design Data Products ...