Data validation in Excel is used to restrict user from entering unwanted value or text into the cell.
It can also be used to create a simple dropdown box so that user can select the desired value from a list.
To know how to set up a cell with data validation, click here.
