Data validation in Excel

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.

Download dataset to practice

This is a small example a data validation but will help you understand better.

Start data validation configuration

Data validation excel

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 

How to remove duplicates in Excel file

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also
Back to top button