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