13 March 2018
Data Validation is a very useful Excel tool. It controls what can be input into a cell, to ensure its accuracy and consistency.
In this blog post we will explore 11 useful examples of what Data Validation can do:
- Allow uppercase entries only.
- Prevent future dates.
- Creating drop down lists.
- Dependent drop down lists.
- Prevent duplicate values.
- Allow only numeric or text entries.
- Validate an entry based on another cell.
- Allow the entry of weekdays only.
- Restrict the text length.
- Entries contain specific text.
- Create meaningful error messages.