Excel Dynamic Dependent Drop-down Lists for Entire Column – No Complicated Formulas Required

Microsoft Excel Tips and Tricks

I demonstrate how to create dependent drop-down lists in Microsoft Excel. A dependent drop-down list displays values dependent on another drop-down. In our example, our first drop-down displays regions and our second, retail branches within the region selected in the first drop-down.

Credit Chester Tugwell