Question: how to select value from drop down list in excel?
Answer: On the second sheet, type the items you want to appear in the drop-down list. ... 
On the first sheet, select cell B1.
On the Data tab, in the Data Tools group, click Data Validation. ... 
In the Allow box, click List.