Making a cascading (dependent) Excel drop down list
Today, we are going to investigate this feature in-depth and learn how to create cascading drop down lists that display choices depending on the value selected in a previous dropdown.
- Creating a simple Excel dependent dropdown list
- Cascading drop-down lists with multi-word entries
- Block changes in the primary drop-down list
- Make a dynamic depending drop-down list
How to create a simple cascading dropdown in Excel
Making simple dependent drop-down lists in Excel is easy. All you need is a few named ranges and the INDIRECT formula. This method works with all versions of Excel 2007, 2010 and 2013.
1. Type the entries for the drop-down lists.
First off, type the entries you want to appear in the drop-down lists, each list in a separate column. For example, I'm creating a cascading dropdown of fruit exporters and column A of my source sheet (Fruit) includes the items of the first dropdown and 3 other columns list the items for the dependent dropdowns.
