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.

1. Select the columns or range of cells, where drop down list is to be created.