Cascading drop downs enhance usability of your dashboards & interactive workbooks. A cascading drop-down is a 2 or more level selection mechanism. When you have 100s of selection choices, instead of creating one massive drop down or combo-box, you can set up multiple levels of drop downs, so that users can narrow down their selection. For example, users can select Country, State and then City using cascading drop downs.
There are many ways to setup cascading drop downs. You can use formulas coupled with either data validation or form controls. You can also use Slicers. In this video we will review these techniques.
Cascading drop downs in Excel – Video Tutorial:
You can also watch this video on our YouTube channel.
Download Cascading Drop Downs Example Workbook
Please click here to download the cascading drop downs workbook. Examine the named formulas & slicer settings to learn more.
Companion material to learn more
Please go thru below links to learn more about cascading drop downs in Excel.