Making a Excel Drop-Down List.

In this tutorial we are going to make a list of selected item for a drop-down lists in 5 simple steps.
Following are the steps.
1.) Open Excel
2.) Create any list with the type specified in the top of the list. For e.g I have created a Type list of different kinds of drinks.

3.) Hit Ctrl+Shift+F3 by selecting the list. a popup will apper Tick on the Top row and click ok.

                               

alternately you can also select only the names of the list and may enter name in the name box in excel. 

                                 

and press enter 

either way your list will be created mine is created with Type name 

4.) After that click on a cell on which you may want to create a drop-down list. and click on Data and in Data click on Data Validation

.                            

on Data Validation in Allow: Click on List and in Source; Fill the name of your list that you have created with = and press OK.

                             

5.) Check your cell you should now have the Drop-down list created.

                            

Next is for creating a Dependent Drop-down list.