Please teach me how to implement two level drop down menu selection in Excel

The operation steps of the drop-down menu to implement multi-level linkage in Excel are:

1. Excel

2016 as an example, open the excel sheet;

2. Create a table in the F:H column with the first-level menu as the title and the second-level menu arranged vertically;

3. Select the first-level menu setting area, and under the "Data" option, "Data Validation" (EXCE

In the following versions of "Data Validity"), select "Series" for the "Settings" option, select F1:H1 cell, OK;

4. Select the F:H column, select "Create from Selection" under the "Formula" option, check "First Row" in the "Create Name for Selected Area" dialog box, and press "OK" to complete the creation of the name;

5. Select the secondary menu setting area, in the "Data Validity" under the "Data" option, select "Series" for the "Settings" option, **Input=indirect(A2).

Are you sure; 6. In the first-level menu setting area, click the drop-down option button to select the corresponding menu content;

7. In the secondary menu setting area, click the option button, and the secondary menu corresponding to the primary menu will pop up for selection.

1. You can first list all the names of your drugs in excel and sort them;

2. Copy the ordered drug names into the text file, and separate the drug names with English commas;

3. Select the cell that needs to fill in the name of the drug, in the [Data]-[Validity] dialog box, Settings-Allow to select [Sequence], copy the name of the drug just copied to the text document in the text box below, and then OK.

A drop-down menu in Excel where only one item can be selected is called the Data Validation List. To set a drop-down delay menu that allows two or more drop-downs to be selected, you can do so by following these steps:

In Excel, create a range of cells for allowing the code to select multiple options;

From the Data checklist, select the Data Validation command;

In the Data Validation dialog box, select the List type;

In the ** box, enter a list of options, separated by a comma;

In the 'Allow' box, select the 'Custom' option;

In the Formula box, enter the following formula: =countif(option cell range,"1")>2

Click the OK button.

After the setting is completed, you can select the desired option in the options cell and click confirm. Note: Where,"Options cell area"The range of cells that you define allows you to select multiple options"2"This is the minimum number of options that are allowed to be selected, which can be changed according to your needs.

You need to set up the control to cooperate with VBA

Hello, Steps:

1. First of all, take a look at the original data, the original information is in a worksheet, the first line is the name of the province and city, and the following several behaviors correspond to the place names and district names under the provinces and cities. You need to create a secondary drop-down menu for column A and column B in another worksheet.

2. First of all, select all the data of the original table (including the extra blank cells), and press F5 or Ctrl+G to bring up the positioning dialog box. Select Targeting in the lower-left corner.

3. As shown in the figure below, select [Constant] and click the [OK] button. In this way, all non-empty cells are selected.

4. Select [Data] - [Validity] - [Create from Selection] in the ribbon.

5. Since the title is in the first line, select [First Line] as the name, and then click the [OK] button.

6. After the operation is completed, you can see the defined name in the name manager.

7. Select the name of the province and city in the first row (also locate the non-blank cell), enter the word "province and city" in the name box, and press enter, so that the name of a "province and city" is defined.

8. Select the A2 cell of the operation interface and select [Data] - [Data Validity].

10. In this way, a drop-down menu of province and city information is generated in cell A2.

11. In the same way, select cell B2, set the data validity, and enter the formula: =indirect($a$2).

12. After setting, when "Hebei" is selected in cell A2, the drop-down menu of B2 returns the information of "Hebei"; When "Beijing" is selected in cell A2, the drop-down menu of B2 returns the information of "Beijing".

<> as shown in the figure above: 1. You need to enter the personnel directory of the technical department and the marketing department in column E and column F first.

2. Enter the formula in cell d2: limb brigade huai=if($a$1="Marketing Department",if(f2=0,""f2),if(e2=0,""e2)), copy and pull down.

3. Click on cell A1, select the town file and select the menu item "Data - Data Validity - Allow (Sequence) - **(Technical Department, Marketing Department), and then OK, the drop-down menu setting of cell A1 is complete.

4. Click in cell B1 and select "Data - Data Validity - Allow (Sequence) - **(=$d$2:$d$16), and then confirmed, the drop-down menu setting of cell B1 is completed.

Then you need to select the operation, select one of the parts in cell A1, and then select the drop-down menu in cell B1, and the menu content in column B will have different effects due to the difference of A1.

excel uses the mold bend to do the secondary drop-down menu, and always reports that "the list source must be the data list after demarcation" is caused by the wrong setting, and the solution is:

2. Select the data in columns A and B, press CTRL+G at the same time, the positioning dialog box appears, and click Positioning Condition.

3. In the Positioning Condition dialog box that appears, select Constant, and click the OK button.

4. Click Formula--Create from Selection, select the first row in the dialog box that appears, and click the OK button.

5. Click the cell code as shown in the figure, click Data - Data Validity, select as Series, and select the corresponding data source, click the OK button, and the first-level drop-down list is set up.

6. After setting the data source, click the and Stuffy OK button, and the secondary drop-down list will display the corresponding options.

excel how to make a secondary drop-down menu setting. 1. Click to open the window menu and click the drop-down menu. In the pop-up window, find the template you want to use and click Copy.

2. If we want to create a new set of windows, click on the first branch and select Open. Once you click on the icon, a window will pop up. 3. Create a new layer in it, and use the image to adjust the color color cavity saturation, as shown in the figure below.

4. Change the layer mode to or wash the filter color (the corresponding color is a little brighter, the hue is 15%, and the saturation is 65%), so that you get nearly 300 white. 5. After selecting the layer, press the C button, place the mouse on top of the layer, and click to select the blend option. 6. Click on the custom shirt shape in the drop-down arrow below and select it, as shown below.

7. Click on the Bézier shape in the left arrow and select it as the unit fixed width. 8. Click on the Bézier shape of the shirt in the outer arrow.

The steps of excel to make a secondary drop-down menu are as follows: select the area where you need to set the first-level drop-down menu, click on the data validity settings, click on the selection sequence, click **, select the first-level drop-down menu, and select the data area of the first-level drop-down menu (click OK to have and the drop-down menu, continue to the second level below.) Select the first second-level menu, click the formula - define the name (or press CTRL+F3 to open the name manager operation to create) The name is written as the name of the corresponding level (Zhejiang) Click OK, the same method to complete the second level menu Jiangsu select the area where you want to set the level 2 menu, click on the data to sell the bridge - data validity, select the allow sequence in the pop-up window, **Enter =indirect(A1) Click OK to complete the creation of the secondary menu.

Similarly, redefining the name of the city can continue to create a joke for the multi-level menu touch.

The operation steps of "excel drop-down menu level 1 level 2" are as follows:

1. Open the excel sheet;

2. Create a table in the F:H column with the first-level menu as the title and the second-level menu arranged vertically;

3. Select the first-level menu setting area, in the "Data Validity" under the "Data" option, select "Series" for the "Settings" option, select F1:H1 cell, OK;

4. Select the F:H column, select "Create from Selection" under the "Formula" option, check "First Row" in the "Create Name for Selected Area" dialog box, and press "OK" to complete the creation of the name;

5. Select the secondary menu setting area, in the "Data Validity" under the "Data" option, select "Sequence" for the "Settings" option, **Input=indirect(A2) OK;

6. In the first-level menu setting area, click the drop-down option button to select the corresponding menu content;

7. In the secondary menu setting area, click the option button, and the secondary menu corresponding to the primary menu will pop up for selection.

Level 1: Implemented with "Series" of Data Validity: Select the cell or range, the Data Tool Data Validity, select "Series" in "Allow", enter the comma-separated options in "**", or use the formula to get the range reference of the row or column of "Options".

Method 1 Open Excel, for example, the drop-down menu we want to do in this example is Experience, Encyclopedia, Know. At this time, we need to select the cells (which can be one or more) for the drop-down menu. After selecting the cells, click on the data --- validity.

At this time, you will be taken to the Validity Settings option. In the Settings tab, select Validity Criteria as Sequence, tick the Provide drop-down arrow, **Enter Experience, Encyclopedia, Know.

When setting **, you can also click to set the selection range, such as: =$g$13:$g$15. Of course, the premise is that we enter the experience of $g$13:$g$15, and we know. When you're done, click OK.

At this time, we can see that there is a drop-down arrow on the selected cell, and we only need to click the arrow to select it when entering, which is suitable for selecting when the content of a row or column of input is mostly similar when we are in the office.

Hope this documentation is useful to you.

Customize the name first;

Then use. Data validity.

function to be realized. For menus at level 2 and above, be sure to use the direct command in data validity.