microsoft excel use a dropdown menu to change workbook

Step-01: Define Selection Lists with Named Range

That means the smartphone models here will be shown based on the selection from the initial drop-down list. Now we have to follow the procedures to make the next drop-down list in Cell C14 and this drop-down list will be dependent. Create Dependent Drop Down List Based on Primary Selection If you click on the drop-down icon in Cell C13, the list will show the defined brand names.Ģ. So you’ve just made the first drop-down list with a list of smartphone brands in Cell C13.Enable editing in the Source box and then select the range of cells: B4:C4 and press OK.In the Allow box, select List from the options. Select Cell C13 > Under the Data ribbon, choose the Data Validation.Now, we will use the Data Validation feature from the Data tab to create an independent drop down list. Step-02: Use Data Validation Feature from Data Tab Read More: Create Excel Drop Down List from Table (5 Examples) It will occupy the independent drop-down with the list of two smartphone brand names. In the secondary table at the bottom, we have to make a drop-down in Cells C13. There are two columns in the table representing several smartphone models of two popular brands. In the following picture, a random data table has been shown. To create a drop-down list in Excel, first of all, we need a data table or a dataset. Step-01: Prepare Excel Data Table with List of Items An independent drop down list contains the options which are not dependent on any other value. In the first example, we will make use of the Data Validation feature for selection of items to make an independent drop down list. Use Data Validation for Selection of Items to Make Independent Drop Down List Here, we will show you 5 suitable examples of creating a excel drop down list depending on selection.ġ. You can make a drop down list by using the Data Validation feature, Excel table or VBA in Excel. Drop Down List Depending on Selection.xlsmĮxcel Drop Down List Depending on Selection: 5 Suitable ExamplesĪ drop down list can be independent or dependent on another primary selection.

Microsoft excel use a dropdown menu to change workbook