Online sheet  ->  Validation

Apply data validation to cells


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.

sheet

To start use data validation, you can follow the steps:

Sheet supports 4 type of data validation

sheet

Number validation


Number validation includes the following type of rules:

sheet

You can select Remove validation button to remove it.


Date validation


Date validation includes the following type of rules:

sheet

You can select Remove validation button to remove it.


List validation


List validation allows your enter a list of item and let user select one of them.

sheet

You can select Remove validation button to remove it.


Text validation


Text validation includes the following type of rules:

sheet

You can select Remove validation button to remove it.