What is Data Validation and Settings
In this post we describe What is Data Validation? so please read this post for better use of this function.
Data Validation
Data Validation option in Excel accept only valid set value and ignore invalid value. By this option you typed data entry fast and accurately for example if you select range A2:A10 and set value only numeric entry between 50 to 500 then data validation only except between 50 to 500 numeric value other entry is ignores.
Use of Data Validation Settings
When you click this option then display some options like-
Also Read- Excel Index and Match Function use with Example in Hindi
Any Value
In this features of data validation you typed any values like – Numeric, Text, Decimal, Time etc.
Whole Number
In this features you set only Numeric value greater then , less then, between etc.
Decimal
In this featured you set only Decimal value like- .00
List
Date
In this features you choose and set Date formats.
Time
In this option you choose and set Time formats.
Text Length
In this option you choose and set Character Lengths.
Custom
In this option you set data validation according to formulas.
Input Massage
When you click this option show below figure
You fill in this box Input massage. When user type data in selected cell then input massage show.
Error Alert
In this option you set Error Alert Massage. When user type invalid data in selected range then show error alert massage (Figure shown below)
Conclusion
I hope after reading you better understand What is Data Validation and its uses. If any question and suggestion for related post please comment us.
