Smart Excel Data Validation - Very Useful to restrict entries in Drop Downs, Text, Number fields.
Smart Excel Data Validation - Very Useful to restrict entries in Drop Downs, Text, Number fields.
In this video, we will learn making a drop down list in Excel and applying validation on it. We will also cover below topics -
1. How to create dynamic drop-down lists in excel.
2. How to put validation on drop downs in excel.
3. How to restrict cell input to data that fall between two values or dates which are greater than today's date.
3. How to restrict cell input to values that have fixed length. It can be greater or smaller.
4. How to restrict numbers input to fall between some values.
There are some more advanced topics that will be covered later on.
This video explains the above options in Hindi. Suggestions are most welcome.
Thanks.
#excel.