How To Create Excel Drop Down List In 5 Steps

If you want to know How To Create Excel Drop Down List, then this article is for you. Here you learn the Dependent Dropdown list Step by Step Process.

How To Create Excel Drop Down List

Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values.

How to Create Excel Dependent Drop Down List

Here I Explain with an example. I separately create two lists, In one list Countries and their Cities. In Second list Only Country. Because cities are dependent on the country.

If Country change then cities are also changing. Make sure you also create a list as per What is Dependent and what is independent.

Let’s Start to Create a Dependent List

Select all Independent List

Make sure to select all independent lists.

Click on Create from Selection

After that go to Formulas then click on Create from Selection

Then you have four options, Top Row, Left Column, Bottom Row and Right Column.

In this case, I select Top Row because the Country is in Top Row. You select as per your Data. Then click OK.

Click on Data Validation

After that first select cell where you want to create, then go to Data and click on Data Validation.

Validation Criteria

Allow drop-down menu select List, In Source section I write =country. because I select Country for Form Selection(Top Row). Then click OK.

Now you see a drop-down list is Create for all countries. Next, create a dependent drop-down list for cities.

The process is almost same.

First Select all independent data then go to Formulas, click Create Form Selection, then select Top Row(it’s dependent on your data). Click Ok.

Data Validation(=INDIRCT())

Next step first select cell where you want to create a drop-down list then go to Data, Data Validation.

In Allow section select List, then in Source write =INDIRECT(select that cell where you first create a drop-down list). In this case, I create a list on D12 cell.

Now you successfully create a Dependent Drop-Down List.

Conclusion

In Excel create a drop-down list looks difficult but not that much once you create its looks easy. It saves lots of time also. If you find it difficult what I show the above example first you do the same thing before a real task.

If you like my explanation on How To Create Excel Drop Down List then share it with your friends on social media.

If you have any questions or suggestion then comment below, I try to answer it all.

Also Read:- How To Use Microsoft Excel Vlookup Function In 4 Steps