how to make a drop-down menu bar in the WPS table:
Create a new Excel table first.
After you save Excel, click the Insert option above.
At this point on the right-hand side of the toolbar will see a similar Drop-down list icon, named "combo box", click on the combo box icon.
Then hold down the left mouse button and drag in Excel, and then you will see that you have drawn a drop-down list box.
When the Drop-down list is empty, we fill out a column of text elsewhere, which will serve as the content option for the Drop-down list.
Then right-click in the Drop-down list to select the Format object formatting option.
Then in the pop-up window you will see the data source options, click on the following icon, and then pop up a long box.
Then drag the mouse to select the data that you just filled, and then the data will automatically fill in the bar above, then click on the icon behind the strip.
It then goes back to the "Format Object" dialog box and clicks on the OK button.
When you click the Drop-down list box, you will see that there are already data options.