Course Content

If you are facing any issue in playing video please use Firefox browser.

Course Content


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 is the most widely used spreadsheet software in the world, and it has a lot of features that can help you create financial reports or data-driven business decisions. One of these features is data validation. Data validation allows you to control what type of data an input value will enter into your worksheet. Data Validation in Excel is the most customizable, powerful, and easy-to-use data validation add-in on the market. It allows you to create extensive data validation rules for an organization's most critical worksheets.

Data Validation is a feature of Microsoft Excel that helps you validate the accuracy of your data. Data Validation is an important feature for business users because it helps them manage data accuracy and reliability. It also protects the enterprise from costly mistakes. Data validation tools are available in some other software, including Google Sheets, Microsoft Power BI, and SAP BusinessObjects.

You can improve your productivity by removing unnecessary data validation in Excel. Here are the ways: 1. Remove a single cell from the spreadsheet 2. Delete rows and columns 3. Delete whole sheets of data 4. Delete the whole worksheet 5. Insert a new sheet into the workbook

Recommended Courses

Share With Friend

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

Download The Apps

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
297K+ Downloads
App Download Section Circle 1
4.5 Rating
App Download Section Circle 2
10K+ 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