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
Post a Comment