Make drop down menu in excel

add drop down in excel

Data > Data Validation

Allow:  List
Source: Cell Range for valid options

in-cell drop-down: enabled by default