This tutorial explains how to make a drop-down list in Excel.
- Enter some values in single cells (f.e. H3:H7)
- Click on the Data menu and navigate to Data Validation
- Click Data Validation…
- In the Data Validation form, on the Settings tab
- Allow: List
- Source: select the cells where you declared the values
- Click OK
- Now, you have a drop-down list
