Data Validation in Excel | Excel Data Validation

Data validation is a feature in Excel, it is used to control what a user can enter into a cell.
In our example, we would try to explain it. In data validation, we try to make sure a value is number and can be restricted, date and characters can also be restricted.
Below is a example of data validation in Excel in which we would restrict the cells to enter whole number between 0 to 10.
Create a Rule
We would create a rule for this
Steps For Validation 1. Select Cell B2
2. On the Data tab, in the Data Tools group, click Data Validation.

Go on to the Settings tab:
3. In the Allow list, click Whole number.

4. In the Data list, click between.
5. Enter the Minimum and Maximum values.
Input Message
A Input messages appear when the user selects the cell and tell the user what to enter.

On the Input Message tab:
1. Check 'Show input message when cell is selected'.
2. Enter a title.
3. Enter an input message.
The message would be appeared for the cell and user is restricted to enter only those numbers. In this article we tried to cover the following. Data Validation in Excel
Data validation in excel 2016
Data validation in excel 2019
Data validation in excel 365
Data validation in excel definition
Data validation in excel list