For Creating a Drop Down List just follow the few step shown below.
- Select a cell where you want to have your drop down list.
- Go to Data Tab
- Go to Data Validation and click on it and one dialog box will pop up.
- Select List from that dialog box and go down one step into source row in that dialog box.
- Now select the range for the data you want to create a drop down list. For Ex:- A2:A10
- Once Selected just hit ok button in the dialog box and your drop down list is prepared.
- For Example see the step shown in the image and a video provided below.