How to make excel two-level linkage drop-down menu

You can create a drop-down menu smoothly and quickly by customizing the name. The steps are as follows:

Select the area where the first drop-down menu needs to be set.

Click? Data? ? data validity

Set the allowed selection order.

Click the source and select the data area of the first-level drop-down menu.

Click OK to get the drop-down menu and continue to Level 2 below.

Select the first secondary menu content.

Click the formula to define the name (or press Ctrl+F3 to open the Name Manager and create a new name).

The name is written as the name corresponding to the first level (Zhejiang)

Click OK to complete the second secondary menu Jiangsu in the same way.

Select the area where the secondary menu needs to be set.

Click Data-Data Validity

Select the allowed sequence in the pop-up window. Source input = indirect (A 1).

Click OK to complete the creation of the secondary menu. By redefining the city name, you can continue to create multi-level menus.