Step 1: Load the control: click the office button in the upper left corner-》excel Options-Common-to display the development tool tab in the ribbon; Click Development Tools-Insert-Form Control-Combo Box;

Step 2: Create and name controls to realize the first-level menu;

The number in cell A2 indicates the position of A 1 in the drop-down list.

Step 3: Customize the name as needed, set the control format, and realize the secondary menu;

The number in cell B2 indicates the position of B 1 in the drop-down list.

User-defined name: group =OFFSET(Sheet 1! $B$2, match (offset (Sheet 1! $A$2，Sheet 1！ $A$2，)Sheet 1！ $C$3:$C$99，)，，COUNTIF(Sheet 1！ $C$3:$C$99, offset printing (Sheet 1! $A$2，Sheet 1！ $A$2，)，)

Q: How to implement a two-level drop-down menu with form controls?

A: There are three steps:

Step 1: Load the control: click the office button in the upper left corner-》excel Options-Common-to display the development tool tab in the ribbon; Click Development Tools-Insert-Form Control-Combo Box;

Step 2: Create and name controls to realize the first-level menu;

The number in cell A2 indicates the position of A 1 in the drop-down list.

Step 3: Customize the name as needed, set the control format, and realize the secondary menu;

The number in cell B2 indicates the position of B 1 in the drop-down list.

User-defined name: group =OFFSET(Sheet 1! $B$2, match (offset (Sheet 1! $A$2，Sheet 1！ $A$2，)Sheet 1！ $C$3:$C$99，)，，COUNTIF(Sheet 1！ $C$3:$C$99, offset printing (Sheet 1! $A$2，Sheet 1！ $A$2，)，)

Note: The drop-down button implemented by this method is always displayed, which is different from the data validity.