Course Content

Course Content

Data Validation in MS Excel

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.


Excel data validation allows you to control the type of data that is entered into your worksheet. Excel data validation, for example, allows you to limit data entries to a dropdown list selection and to restrict specific data entries, such as dates or integers, to a predetermined range.

Excel's data validation tool restricts what a user can type into a cell. For example, data validation could be used to ensure that a value is between 1 and 6, that a date is within the next 30 days, or that a text entry is less than 25 characters.

  • To validate, select one or more cells.
  • The Data Validation dialogue box will appear.
  • Select Custom in the Allow box of the Data Validation dialogue window's Settings tab, then type your data validation formula in the Formula box.
  • Click the OK button.

  • Select a sample of data. Select the data to be sampled.
  • Check the database for errors. Before you relocate your data, make sure you have all of the necessary information in your current database.
  • Verify that the data format is correct.

The process of confirming the correctness and quality of data is known as data validation. It is implemented by incorporating various checks into a system or report to ensure that input and stored data are logically consistent. Data is entered into automated systems with little or no human intervention.

Recommended Courses

Share With Friend

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

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • 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