Combine Dropdown Permit For Free

Create multi-level dependent drop down list in Excel First, create the first, second and third drop down list data as below screenshot shown:Then, select the first drop down list values (excluding the header cell), and then give a range name for them in the Name box which besides the formula bar, see screenshot:

In Word, open a blank document and click the Developer tab. (If you don't know how to enable the Developer tab, read How to: Show the Developer Tab on the Ribbon. ) In the Controls group, click the Legacy Form dropdown and choose Drop-Down Form Field. Repeat step 2 to add a second dropdown field.

To create the drop-down list: Select the cell or cells you want the drop-down list to appear in. Click on the Data tab on Excel's ribbon. Click on the Data Validation button in the Data Tools group. In the Data Validation dialog, in the Allow: list select List. Click in the Source: box.

Under Insert controls, click Multiple-Selection List Box. If you cleared the Automatically create data source check box in step 3, select a repeating field in the Multiple-Selection List Box Binding dialog box to which you want to bind the multiple-selection list box.

All you have to do is right-click anywhere on the ribbon at the top and select customize ribbon.MoreAll you have to do is right-click anywhere on the ribbon at the top and select customize ribbon. Then this window will pop up and you'll see over here on the right-hand side your main tabs.

Under Insert controls, click Combo Box.... Click Add. In the Value box, type the text that you want to store if a user selects this entry. In the Display name box, type the text that you want to display for this entry, and then click OK. Repeat steps 1 through 3 for each entry that you want to add to the list box.

Add the Dependent Drop Down On the DataEntry sheet, select cell C3. On the Ribbon, click the Data tab, then click Data Validation.. From the Allow drop-down list, choose List. In the Source box, type an equal sign and INDIRECT function, referring to the first data cell in the Produce Type column:Click OK.