How to add a secondary drop-down menu to a wps table - steps to add a drop-down menu to a wps table

php editor Banana will introduce you to the steps of adding a secondary drop-down menu to a wps table. Through the secondary drop-down menu, you can organize and process data more flexibly. In WPS tables, adding a secondary drop-down menu is not complicated. You only need to follow certain steps to achieve it easily. Next, let us learn in detail how to add a secondary drop-down menu in a wps table!

1. Open the table file and enter the text that needs to be set as a drop-down list. Select the formula in the menu bar and click the Specify button in the property bar.

2. Choose the appropriate creation method according to your own situation. Here, select the first line and uncheck the others.

3. Find the cell column where the drop-down list is placed, select it, select the data option in the menu bar, and click Validity in the property bar.

4. Set the valid condition permission to sequence, and set the source to the first row. Just drag the mouse to select it. It also represents the content of the first-level drop-down list. Click OK. .

5. Then select the cell where the secondary drop-down list is placed and click Validity on the property bar.

6. Also set the allowed condition to sequence, set the source to =INDIRECT(G1), and click OK. G1 here is the cell of the first-level drop-down list.

7. Complete the setting of the secondary drop-down list, and you can see the results as follows.

The above is the detailed content of How to add a secondary drop-down menu to a wps table - steps to add a drop-down menu to a wps table. For more information, please follow other related articles on the PHP Chinese website!