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.