How to make a secondary linkage drop-down menu in wps How to set up a secondary linkage drop-down menu option in wps

We will need to create a drop-down menu when using WPS tables, so many users are asking how to make a WPS secondary linkage drop-down menu? Users who are unclear can take a look at the relevant strategies on how to set up secondary linkage drop-down menu options in WPS brought to you by this site. How to set the secondary linkage drop-down menu option in WPS Method 1. Open the WPS table, select the secondary linkage menu corresponding table, use the key combination [CtrI+G] to open the positioning dialog box, select [Constant], and click [Position].

2. Click [Specify] under the [Formula] menu.

3. Select [First Line] in the pop-up dialog box and click [OK].

4. Select the [Province] column, click [Data] - [Validity], select [Sequence], select the province name in [Source], and click [OK].

5. Then select the [City] column, click [Data] - [Validity], select [Sequence], enter the formula [=INDIRECT (D2)] in [Source], and click 【Sure】.

6. In this way, the two-level linkage drop-down menu in the table is set up.

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