To create a drop-down list in Excel, you will use the Data Validation feature. This feature enables you to set specific criteria for the data that can be entered into a cell.

Learn to create efficient, interconnected Excel drop-down lists using range functions and data validation techniques. Multi-level drop-down ...

Next, in the Allow field of the Data Validation dialog box, select "List." Finally, activate the "Source" field, and select the cells containing the values that you want to appear in the drop-down ...