Examples of using Second drop down list in English and their translations into German
{-}
-
Colloquial
-
Official
-
Ecclesiastic
-
Medicine
-
Financial
-
Ecclesiastic
-
Political
-
Computer
-
Programming
-
Official/political
-
Political
Now to create the second drop down list.
When Tea is selected in the parent drop down list, you can only select the tea items from the second drop down list.
Select a cell you want to create the second drop down list, click Data> Data Validation> Data Validation.
Select the second table that you want to merge from the second drop down list;
Go ahead to click the second drop down list and select Equals(or Contains), and type type the second condition into the following box;
In the opening Duplicate Values dialog box, specify the highlight color in the second drop down list, and click the OK button.
Select first criterion from first drop down list, then select second criterion from second drop down list, and if you want to select cells meeting two criteria simultaneously, check And option, if you want to select cells meeting one of the two criteria, check Or option.
In the Value Filter dialog, select the data field that you want to hide its zero values from the first drop down list, and choose does not equal from the second drop down list, at last enter 0 into the text box, see screenshot.
Select a cell or multiple cells to locate the second drop down lists and click Data> Data Validation> Data Validation to open.
Inserting normal drop down list in Google sheet may be an easy job for you, but, sometimes,you may need to insert a dependent drop down list which means the second drop down list depending on the choice of the first drop down list. .
Select the column you want to filter by in the first drop down list, and in the second drop down list, select Text, and select Contains in the third drop down list, then type~*(the asterisk symbol) into the last text box.
Select the data range that you want to filter, and click Kutools Plus> Super Filter to go to the Super Filter dialog, in the dialog box, click the horizontal line beside the relationship AND, then choose the columnname that you want to filter by from the first drop down, and from the second drop down list, select Text format, see screenshot.
You have to manually remove the invalid value from the second drop down list after selecting changed in the first one.
And then you can create the second dependent drop down list, click a cell where you want to put the second drop down list, and then click Data> Data validation to go to the Data validation dialog box, choose List from a range from the drop down beside the Criteria section, and go on clicking the button to select the formula cells which are the matching results of the first drop down item, see screenshot.
And in the A Date Occurring dialog box, from the first drop down list, choose your date that you want to highlight, and in the second drop down list to choose one color that you like to format the certain date, see screenshot.
Then choose And option,and go on selecting does not equal from the second drop down list, then choose the blank row again from the drop down, see screenshot.
In the Select Specific Cells dialog, check one type of selection you want, select Greater than from first drop down list and select the start date into next textbox, and go to second drop down list to select Less than and select the end date into the beside textbox, then check And option.
Note: You can also customize thefill color with selecting the Custom Format from the second drop down list, and then specify the custom fill color on the Fill tab of Format Cells dialog box.
For example, here are some country names, and every country has its own scenic spots, and now I want to create the first drop down list about country name,and then create the second drop down list about the scenic spots, which means that, I only can choose the scenic from of the second drop down list based on the selected country in first drop down list. .
Click OK, and the second dependent drop down list has been created at once, see screenshot.
At last, click Save button, and the second dependent drop down list has been created successfully as the following screenshot shown.