Data validation

Data validation is a feature in Excel used to restrict what a user can enter into a cell.

Data validation can also be used to provide a dropdown menu with predefined choices when a cell is selected.