The setting steps of "excel two-level linkage drop-down menu" are as follows:

1, open the Excel worksheet;

2. Establish a first-level and second-level menu list, with the first level in the header position;

3. Select the setting area. In data validity and settings under data, select serial, and the data source is F 1:H 1 area;

4. After confirmation, generate a first-level drop-down menu;

5. Select a data source, click Create Based on Selection under Formula Options, and select Create with the name of "First Column";

6. Select the setting area of the two-level linkage drop-down menu. In data validity and setting under data, select serial, source input = indirect (a1);

7. After confirmation, a secondary drop-down menu linked with column A can be generated.