How to make a secondary drop down menu in Excel

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

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

Select [Constant] and click the [OK] button. In this way, all non-empty cells are selected.

Select Data - Validity - Create from Selection on the ribbon.

Since the title is on the first line, select First Line as the name, and then click the OK button.

Once you're done, you'll be able to see the name of the definition in the Name Manager.

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 a name of "province and city" is defined.

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

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

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

After the setting, when the A2 cell selects "Hebei", 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".

**Make drop-down menu input data, it is very efficient to improve work efficiency, and you can also make a second-level linkage drop-down menu, that is, after the first-level menu is selected, the second-level menu only displays the content associated with the first-level menu for us to choose.

1. First open the excel** you want to make a secondary menu, then select the data area, click [Gong Rotten Beam Type], and select [Create according to the selected content].

2. In the dialog box that pops up, cancel the front of the leftmost column and check only the first column.

3. Then start to make a first-level drop-down menu, first select the data frame on the left, and select Data-Data Validity.

4. Then in the dialog box that pops up, select "Sequence", and then click the input box under ** with the mouse, and then frame the first line of the city on the left.

5. This is followed by a secondary drop-down menu, which also selects the data frame first, and then selects [Data Validity].

6. Then select "Sequence", and then ** is no longer to frame the data, but to input the function "=indirect()" hunger and old luck, and the input in parentheses is the letter on the province on the right data + the first serial number of the data city on the left.

7. After operating the above steps, the secondary drop-down menu is ready, and all cities can be selected from the drop-down menu.

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, first click 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 "Adjust" Hue saturation, as shown 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 in the external arrow.