Here you are going to learn the way you can do the data validation in Excel. Data validation option can be used to validate the data in excel. Data in the sense there might be numbers or text based on the requirement. This is the one best features in the excel spreadsheet to restrict end users from committing errors by selecting incorrect data. Also this feature can be used to create many options to end user while updating statements or forms. Data validation has many options and varieties. I am going to give you some of examples to explain you in depth for all the options available in this feature.