Data Validation in Excel

How Data Validation Works In Excel?

Data Validation is a feature which is used to avoid an entry of invalid data.

Data Validation

Select Data > Go to Data Validation

Settings Tab

Click on the Settings Tab >Allow > Select any option

Input Message

Input Message Tab > Customize Message

Error Alert

Enter an invalid Data > Error Alert appears

Leave a Comment

Your email address will not be published. Required fields are marked *