hussain.ijtaba
Data Validation in Excel: How to use it,8 awesome uses of excel data validation
Data Validation in Excel
Data validation in excel is a very useful tool. Its main functionality is to create constraints while data entry in excel. For example, we could put a constraint that no duplicate value should enter in a cell or column or the value entered in a cell should be between 5 to 25. It also reflects a message about the condition required to enter the data in that cell, when we put a wrong entry.
How to add data validation in excel sheet
To apply data validation in excel first we will go to Data >> Data Validation >> Data Validation. After that we will click on Data Validation then we will get an input box as illustrated in the below image.
Data Validation in Excel
This box have three tabs, Settings, Input Message and Error Alert. In the setting tab we have validation criteria , we can use Allow drop down to choose validation rules. There are 8 different options there, the first one is Any value which allows all value to enter but we can use input message and error alert in combination to show some alert information. All eight options are mentioned below.
Setting option in excel
The uses for all seven options are explained in the below image.
OptionsData Validation TypeWhole numberOnly Whole no. can be enteredDecimalOnly decimal (percentage) values can be entered.ListEntries are restricted to a list of items only.DateEntries are restrited to a range of dates only.TimeNo entry of time data outsite the defined frame.Text
Data Validation in Excel: How to use it,8 awesome uses of excel data validation
Data Validation in Excel
Data validation in excel is a very useful tool. Its main functionality is to create constraints while data entry in excel. For example, we could put a constraint that no duplicate value should enter in a cell or column or the value entered in a cell should be between 5 to 25. It also reflects a message about the condition required to enter the data in that cell, when we put a wrong entry.
How to add data validation in excel sheet
To apply data validation in excel first we will go to Data >> Data Validation >> Data Validation. After that we will click on Data Validation then we will get an input box as illustrated in the below image.
Data Validation in Excel
This box have three tabs, Settings, Input Message and Error Alert. In the setting tab we have validation criteria , we can use Allow drop down to choose validation rules. There are 8 different options there, the first one is Any value which allows all value to enter but we can use input message and error alert in combination to show some alert information. All eight options are mentioned below.
Setting option in excel
The uses for all seven options are explained in the below image.
OptionsData Validation TypeWhole numberOnly Whole no. can be enteredDecimalOnly decimal (percentage) values can be entered.ListEntries are restricted to a list of items only.DateEntries are restrited to a range of dates only.TimeNo entry of time data outsite the defined frame.Text