Create Dynamic Drop Down List

This post will guide you how to create a dynamic drop down list in Excel. How do I quickly create a dynamic drop down list in Excel.

Create Dynamic Drop Down List


Assuming that you want to create two drop down list in your current worksheet, and when choose a value in one drop down list, and the values in another drop down list will be updated automatically. How to achieve it. Let’s see the below detailed steps.

#1 select the range of cells A1:B1, go to FORMULAS tab, click Define Name command under Defined Names group. The New Name dialog will open.

create dynamic drop down list1

#2 type one Name in the Name text box. Then click OK button.

#3 select the range of cells A1:A4 to create another defined name.

create dynamic drop down list3

#4 select the range of cells B1:B4 to create one more defined name.

create dynamic drop down list4

#5 create the first drop down list, go to DATA tab, Click Data Validation command under Data Tools group. And select Data Validation item from the pop up menu list. The Data Validation dialog will open.

create dynamic drop down list5

#6 click Settings tab, select List from the Allow drop down list box. And type the formula =Names in the source text box. Click Ok button.

create dynamic drop down list6

#7 the first drop-down list has been created in Cell C1.

create dynamic drop down list7

#8 click Cell D1 to select this cell, go to DATA tab, Click Data Validation command under Data Tools group to create the second drop down list. Click Settings tab, select List from the Allow drop down list box. And type the formula =indirect(C1) in the source text box. Click Ok button.

create dynamic drop down list8

#9 choose one value from the first drop down list, and you will see that the values in the second drop down list will be updated.

create dynamic drop down list9

Related Posts

Cash Denomination Calculator

Every country has different cash denominations, so you may need to calculate the number of different denominations based on the total amount. If it is just a small amount of cash, then you can calculate the different cash denominations manually, ...

7 Best Free Weekly/Bi-Weekly Budget Template

This article will show you some free printable weekly/ BiWeekly budget templates for google sheet and Microsoft Excel spreadsheet applications, and will also explain some of the features or important functions of these templates. This will make it easy for ...

COUNTIF Function: Everything You Need To Know

In previous articles, we have written a lot about the application of Excel COUNTIF function in specific situations. In today's article, we will still focus on Excel COUNTIF function, we will introduce you some basic functions of COUNTIF function including ...

Cap percentage values between 0 and 100

This article will talk about how to cap the percentage values between 0% and 100% in Microsoft Excel Spreadsheet or Google Sheets. If you are a newbie on Excel or google Sheets, you may be able to do this by ...

Calculate Cap Percentages to Specific Value

This article will talk about how to limit the cap percentage of a given amount to a given value in Microsoft Excel Spreadsheet or Google Sheets. If you are a newbie on Excel or google Sheets, you may be able ...

Sidebar