Steps to set drop-down options in WPS Office 2016 table

WPS Office 2016 forms drop-down options for quick selection to improve work efficiency. In this article, PHP editor Xiaoxin introduces in detail the steps for setting drop-down options in WPS Office 2016 tables. From selecting the data area to applying validation rules, he guides you step by step to easily complete the operation.

First create a new excel table.

After saving the excel, click the [Insert] option above.

At this time, you will see an icon similar to a drop-down list on the right toolbar, called [Combo Box], click on this combo box icon.

Then hold down the left mouse button and drag it in excel. After you let go, you will see that a drop-down list box has been drawn.

At this time, the drop-down list is still empty. We fill in a column of text elsewhere, and these texts will serve as the content options of the drop-down list.

Then right-click in the drop-down list and select the [Format Object] option.

Then you will see the data source option in the pop-up window. Click the icon behind it, and then a long box will pop up.

How to make a drop-down menu list in a wps table

After that, drag the mouse to select the data just filled, and then the data will automatically fill in in the bar above, and then click the icon behind the bar.

Then you will return to the [Set Object Format] dialog box and click the OK button.

At this time, click the drop-down list box and you will find that there are already data options.

The above is the detailed content of Steps to set drop-down options in WPS Office 2016 table. For more information, please follow other related articles on the PHP Chinese website!