How to create a Dependent Drop-down list in Excel

A Drop-down list that depends on the selection made using another Drop-down list is called a Conditional or Dependent drop-down list. Following is an example of the same. As you can see, when we go for the degree B.sc in column C, the options are Physics, Mathematics & Chemistry. For B.A, the options are Malayalam,…

Drop-down list in Excel

Create a Drop-Down List A drop-down list also known as a drop-down menu is a graphical control object that offers a list of options. In cells with a drop-down list, the user need not type in anything but can make the selection from the available options. In this blog post you will see, How to set up…