Data Validation in Excel 2010

In this article I am going to explain Data validation in Excel 2010.
  • 3134

Data Validation in Excel 2010

Data validation restrict the type of information that enter in the cell. Data validation use to enter the appropriate and accurate information in the cell. We can set different type of validation such as Numeric validation, Length validation, List validation etc.

To Set Data Validation we have to follow following steps.

Step 1

Open worksheet and select cell where we want to set validation.

selectrowexcel2010.jpg

Step 2

In Data group click on Data Validation.

datavalidationexcel2010.jpg

Step 3

After its a Data Validation Dialog box will be open.

datavalidatindialogbox2010.jpg

Step 4

In this dialog box we can choose different type of validation.

In my Example We set List validation on Name Field and Address field.

Decimal Validation on salary field.

And Length validation on Mobile No field.

validationsettingexcel2010.jpg

validationsetting2excel2010.jpg

Step 5

If we want to enter mobile number that length is more the 10 or smaller then 10 then its will show error.

validatinerrorexcel2010.jpg

Step 6

If we want to enter name then we have to select from the list menu if we enter other name that not exists in the list then its will show error.

validationresultexcel2010.jpg

Ask Your Question 
 
Got a programming related question? You may want to post your question here
 

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.