#Create dropdown in excel how to#

How does this work? вЂ“В The conditional drop down list (in cell E3) refers to =INDIRECT(D3). Now, when you make the selection in Drop Down 1, the options listed in Drop Down List 2 would automatically update. Here, D3 is the cell that contains the main drop down. In the Source field, enter the formula =INDIRECT(D3).In the Data Validation dialog box, within the setting tab, make sure List in selected.

Select the cell where you want the Dependent/Conditional Drop Down list (E3 in this example).

Fruits named range refers to all the fruits in the list and Vegetables named range refers to all the vegetables in the list. Doing this creates 2 names ranges (вЂFruitsвЂ™ and вЂVegetablesвЂ™). In the вЂCreate Named from SelectionвЂ™ dialog box, check the Top row option and uncheckВ all the others.Go to Formulas вЂ“> Defined Names вЂ“> Create from Selection (or you can use the keyboard shortcut Control + Shift + F3).Select the entire data set (A1:B6 in this example).In Source field, specify the range that contains the items that are to be shown in the first drop down list.In the data validation dialog box, within the settings tab, select List.This will open the data validation dialog box. Select the cell where you want the first (main) drop down list.Here are the steps to create a dependent drop down list in Excel: Creating a Dependent Drop Down List in Excel This is called a conditional or dependent drop down list in Excel. If I select вЂFruitsвЂ™ in Drop Down 1, I am shown the fruit names, but if I select Vegetables in Drop Down 1, then I am shown the vegetable names in Drop Down 2. You can see that the options in Drop Down 2 depend on the selection made in Drop Down 1. These are called dependent drop-down lists in Excel.Д«elow is an example of what I mean by a dependent drop-down list in Excel: Sometimes, however, you may want to use more than one drop-down list in Excel such that the items available in a second drop-down list are dependent on the selection made in the first drop-down list.

Read: Here is a detailed guide on how to create an Excel Drop Down List. In the above example, I have used the items in A2:A6 to create a drop-down in C3. This could be useful when you have a list of names, products, or regions that you often need to enter in a set of cells.Д«elow is an example of an Excel drop down list: It shows a list of items as a drop down in a cell, and the user can make a selectionВ from the drop down. Thanks for visiting Geek Excel.Watch Video вЂ“ Creating a Dependent Drop Down List in ExcelДЄn Excel drop down list is a useful feature when youвЂ™re creating data entry forms or Excel Dashboards. Leave your feedback in the comment section. In this way, you can easily understand the steps to Create a Drop-Down List in Excel Office 365.

Now, the drop-down list is created as the below example.

After, inserting the values click Enter and Press the OK button in the dialog box.

Now, it will open the small type field like the below image where you can enter the values separated by a comma.

Next, you have to click the up-arrow given in the Source section.

In that dialog box, you need to choose the List option under the Allow option using the drop-down list.

It will open the Data Validation Dialog Box.

Now, On the Data Tab, Select the Data Validation option under the Data Tools section as in the below image.

First, we need to select the field where we want to add the drop-down feature.

From the following example worksheet, you can see the Column C which has a title of Grade.

#Create dropdown in excel how to#