Making a Dependent Drop-Down List

In This next Tutorial we are going to create a dependent Drop-Down Box that changes while other changes in 5 simple steps.

Here are the steps.

1.) Create a list and its types in excel. I have created types of drinks



2.) The next step is to create the names for the list. It's simple if you don't know check out my previous tutorial.
imp:- The names of the list dependent list must be same as in the main list for e.g if Tea is the item in the main list then the dependent list must contain Tea same name for the dependent list.

3.) After names have been created for the individual list click a cell for creating a list I have clicked in Cell A1 .After that click on the Data tab. Click on Data Validation. and in Data validation select list under Allow: and in source fill the main list title with an = sign.


4.) After that click on another cell which is going to be the dependent cell for this main cell and again click on the Data Validation under the Data tab. and in the Source: fill =INDIRECT(A1) here my Main data is listed in cell A1 therefore it is A1 in brackets you can fill your custom one. After that click ok Don't worry about the error feel free to click Yes. (It is just showing because the A1 cell is empty nothing is selected).




5.) Done Your dependent list is working.

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.