CODE EXAMPLE FOR EXCEL

add drop down in excel

Data > Data Validation

Allow:  List
Source: Cell Range for valid options

in-cell drop-down: enabled by default