PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO DO DATA VALIDATION IN EXCEL?

WHAT IS DATA VALIDATION IN EXCEL?

Data validation means to check the data before entry. It gives us the power to condition the values which can be entered and rejected into any cell.

BUTTON LOCATION FOR DATA VALIDATION IN EXCEL

data validation in excel

STEPS TO DO DATA VALIDATION IN EXCEL

THE STEPS TO VALIDATE THE DATA HAS BEEN DEMONSTRATED USING AN EXAMPLE.

SCENARIO: Let us create a scenario where we need to enter the age and the age should be more than 18 and less than 30.

A cell containing the text “enter your age” is there. Next cell is the one to accept the input from the user.

Click the cell where input is to be taken and click CONDITIONAL FORMATTING button.Following dialog box will open.

data validation in excel
PUT THE CONDITION AS PER REQUIREMENT

THERE ARE MANY CONDITIONS. JUST CHOOSE WHICH ONE TO USE

DATA VALIDATION EXCEL
PUT THE CONDITION AS PER REQUIREMENT

AFTER inserting the input message, set the Error Alert.

data validation in excel
SET THE ERROR ALERT.Click OK.

EXAMPLE OF DATA VALIDATION

We put 31 and the cell didn’t accept the value and showed the error as we set

STEPS TO VALIDATE ALREADY FILLED DATA

Suppose we have a large data and we want to instantly find some data which fulfills our condition.

The following option gives us the option of rounding such data.

data validation of prefilled data

Insert the condition to choose whole numbers from 50 to 99.

Click OK and choose CIRCLE INVALID DATA from the sub menu of DATA VALIDATION BUTTON.

ONLY TWO NUMBERS SATISFY THE CONDITION.

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: