How to make list down on MS Excel

1. We make a list down in MS Excel it is easy to select data in list don't need time to input one by one. please take a look with this.
2. Enter the following data into cells:
   
   A1 - Apple
   A2 - Lemon
   A3 - Mango
   A4 - Chocolate
   D2 - Orange
   
   
3. Click column where the results will be displayed.
4. Click on the Data tab.

4. Click on the Data Validation option from the ribbon to open the menu.

5. Click on the Data Validation in the menu to bring up the dialog box.
6. Click on Settings tab in the dialog box.
7. From the Allow menu choose List.

8. Click on the Source line in the dialog box.

9. Click OK in the dialog box.
10. A down arrow should appear

11. When you click on the arrow the drop down list should open to display the four cookie names.