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

3 thoughts on “How Data Validation Works In Excel?”

  1. This blog is really informative.I have been learning at this institute for the past one year, and my experience has been really good. The teachers are supportive, friendly, and explain everything in an easy way.

    During this time, I have learned different computer skills, including Excel and its basic functions. The practical classes have helped me understand things better and improve my confidence.

    I am happy with my learning experience here and would recommend this institute to beginners as well as students who want to improve their computer skills.

Leave a Comment

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