51. Using data validation to restrict inputs

Using Data Validation to Restrict Inputs

Data validation in Excel ensures that only specific types of data are allowed in a cell. Let’s simulate how it works:

Example: Restrict Inputs to Specific Values

# Allowed Value Input
1 Apple
2 Orange
3 Banana

Type in the input boxes above. Only the allowed values will be accepted.

Comments