Data VALIDATION allows you to enter only that data in a cell that satisfies criteria.

For example:

if you WANT to only have NUMBERS entered in a cell, then you can use Data validation to do this. In case anyone enters something other than numbers, Excel will show an error and not allow that.

Data validation options are available in the data tab.

Data validation can be REALLY helpful when you're creating forms in Excel.

For example: if you want a USER to enter only their age, you can use Data Validation to make sure the cell accepts a numeric value only.

Data Validation allows you to enter only that data in a cell that satisfies criteria.

For example:

if you want to only have numbers entered in a cell, then you can use Data validation to do this. In case anyone enters something other than numbers, Excel will show an error and not allow that.

Data validation options are available in the data tab.

Data validation can be really helpful when you're creating forms in Excel.

For example: if you want a user to enter only their age, you can use Data Validation to make sure the cell accepts a numeric value only.