Use data validation to limit choices during data entry. To create a data validation drop-down list in Excel, you need two things: A list of values and a blank cell to use as the data entry cell.

The Data Validation feature in Excel 2013 offers a List option to confine selections in a cell to a preconfigured series of values. This selection can further influence the values in another list ...