What Is a Dependent Drop-Down List? In a Microsoft Excel dependent drop down list, the list of items changes, depending on the value in another cell. For example: Fruit was selected as Produce Type in cell B3, and the drop down showed the Fruit list in cell D3.
- How do I create an independent drop down list in Excel?
- How do I create a dependent drop down list in Excel with spaces?
How do I create an independent drop down list in Excel?
Select a cell where you want to create the drop down list. Go to Data –> Data Tools –> Data Validation. In the Data Validation dialogue box, within the Settings tab, select List as the Validation criteria. As soon as you select List, the source field appears.
How do I create a dependent drop down list in Excel with spaces?
Go to the cell where you want the second dropdown list, cell G5. Go to Data Validation, select List, and in Source, paste into the Data Validation list. Click OK and you will see that the second dropdown list changes according to the chosen option for the first dropdown.