Data validation is a function that allow you to define restrictions on what data can or should be entered in a cell. You can configure data validation to prevent users from entering data that is not valid. If you like, you can allow users to enter invalid data but give warning when they try to type it in the cell. You can also provide messages to define what input you expect for the cell, and instructions to help users correct any errors.
To start use data validation, you can follow the steps:
Sheet supports 4 type of data validation
Number validation includes the following type of rules:
You can select Remove validation button to remove it.
Date validation includes the following type of rules:
You can select Remove validation button to remove it.
List validation allows your enter a list of item and let user select one of them.
You can select Remove validation button to remove it.
Text validation includes the following type of rules:
You can select Remove validation button to remove it.