Course Content

Course Content

Description

How To Use Data Validation in MS Excel

Now we will see that how we can use data validation in MS Excel.

Suppose if we want to make any column with some particular validation, that is data which needs to be entered in should have some limitations.

For that we will use 'Data Validation' option from our DATA tab. It picks from a list of rules to limit the type of data that can be entered in a cell.

When we use that option we can see a dialogue box opened in front of our screen, which asks to allow certain things to enter in cell like numbers, or alphabets only, or date etc... Also we can mention the length of our data which needs to be entered.

We can also add one input message when we try to write in that particular cell. We can also add error alert style or any title with error message.

Now whenever we will try to enter any data in that particular cell we will be first given a warning that 'Data allowed to enter is characters' or anything we set up. And then suppose if we add something lesser than the character length mentioned it will show our error message asking the user to retry or cancel.

So this is how we can valid any data in our M S Excel worksheet.

FAQs

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download The Apps

Code Scan or Download the app
Google Play Store
297K+ Downloads
4.5 Rating
10K+ Reviews
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere