What is data validation in MS Excel?
Data validation is good functionality to validate data to avoid mistakes or error at the time of
Data processing. Suppose a person entering data of PAN card then you can define length 10
For PAN card number entry. So this will help to write exact 10 text otherwise by mistake
How to apply data validation in MS Excel?
Ans:-Below steps are given to apply data validation.
Step1:- Click on DATA tab in EXCEL.
Step2:- Select a single cell or cell range where you want to apply data validation.
Step3:- Click on data validation drop down and then click on data validation .
Step4:- Now you will se a window with some tabs as below.
Step5:- Select validation criteria for your data in setting tab.
Step6:- Click on Error Alert tab in .
Step7:- Click on OK tab to save validation.
Now test your cells on which you have applied data validation.
Please see below example in GIF image for above data validation implementation.
Data validation is good functionality to validate data to avoid mistakes or error at the time of
Data processing. Suppose a person entering data of PAN card then you can define length 10
For PAN card number entry. So this will help to write exact 10 text otherwise by mistake
How to apply data validation in MS Excel?
Ans:-Below steps are given to apply data validation.
Step1:- Click on DATA tab in EXCEL.
Step2:- Select a single cell or cell range where you want to apply data validation.
Step3:- Click on data validation drop down and then click on data validation .
Step4:- Now you will se a window with some tabs as below.
Step5:- Select validation criteria for your data in setting tab.
Step6:- Click on Error Alert tab in .
Step7:- Click on OK tab to save validation.
Now test your cells on which you have applied data validation.
Please see below example in GIF image for above data validation implementation.
No comments:
Post a Comment