How to set up secondary drop-down menu in Excel

How to set up a secondary drop-down menu in excel

First, we need to view the original data, which is located in a worksheet. The first line contains the names of provinces and cities, and the following lines contain the names of places and districts under the corresponding provinces and cities. Our goal is to create a linked secondary drop-down menu in columns A and B of another worksheet.

First, select all the data in the original table (including blank cells), and press F5 or Ctrl G to bring up the positioning dialog box. Select [Target Criteria] in the lower left corner.

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

4. Select [Data]-[Validity]-[Create based on selected content] in the functional area.

5. Since the title is on 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 two words "province and city" in the name box, and then press Enter, thus defining a "province and city" The name.

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

9. Select [Sequence], enter: =Province and City in [Source], and then click the [OK] button.

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 data validity, and enter the formula: =INDIRECT($A$2).

12. After the setting is completed, 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".

Can I use vb language to realize the content grading of excel drop-down menu?

The following is the method for making two-level classification drop-down menu items. The method for making three-level and above is the same.

We often have to enter the name of the company into the form. In order to maintain the consistency of the name, we use the "data validity" function to build a category drop-down list fill-in item.

1. In Sheet2, enter the company name into columns A, B, and C by category (such as "industrial enterprise", "commercial enterprise", "individual enterprise", etc.) to establish a company name database.

2. Select column A (the column where the name of "Industrial Enterprise" is located), enter the characters of "Industrial Enterprise" in the "Name" column, and press the "Enter" key to confirm.

Imitate the above operation and name columns B, C... as "Commercial Enterprise" and "Individual Enterprise" respectively...

3. Switch to Sheet1, select the column (such as column C) where the "Enterprise Category" needs to be entered, execute the "Data → Validity" command, and open the "Data Validity" dialog box. In the "Settings" tab, click the drop-down button to the right of "Allow", select the "Sequence" option, and in the "Source" box below, enter "Industrial Enterprise", "Commercial Enterprise", "Individual Enterprise"... ...sequence (separate each element with commas), confirm exit.

The above is the detailed content of How to set up secondary drop-down menu in Excel. For more information, please follow other related articles on the PHP Chinese website!