What is data validation
When filling an excel file you need to define some rules that you need to respect when you fill an excel or when other users fill this file.
You want to have a date within a specific range,
you want to have values within specific options
or you want to have a specific text length.
Let’s go trough a real example to understand better.
This is a small example a data validation but will help you understand better.
Start data validation configuration
Set up your data validation settings
As you can see brand should be within this list.
You can add a warning message, in case the user fill in a value which is not in the list.
Read also
