Creating Drop Down List in MS Excel
Enter data in a cell from a list you specify
You can create a dropdown list that gets its choices from cells elsewhere on the worksheet. To do this, follow the below mwntioned steps.
Select the columns or range of cells, where drop down list is to be created.