11 awesome examples of Data Validation

11 awesome examples of Data Validation

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.