Data Validation Rules

Data validation is a critical Excel feature that helps users control the input to ensure data accuracy and consistency.
After editing through the data entry form, data can only be saved if it passes the configured validation rules.

Below is a step-by-step guide to configuring data validation rules

1. Select the cells you want to configure validation rules
2. Select the menu (Data) and then click on Data validation
3. Configure validation rules as desired
4. Optionally configure the error message if the data filled in by the user does not pass the validation rules

Data Validation Rules - Cell configuration

In the example below, the warning message is displayed when the user tries to save data that does not pass the validation rules.

Data Validation Rules - Data entry form