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

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.