How does the WPS table manipulate the filter format?

Source: Internet
Author: User
Tags range

WPS table is often used in our office software, in order to facilitate the normal operation, WPS table has a lot of operating skills, the following look at the WPS filter format, this feature can be in the entire table to filter out the required content. Convenient for us to inquire. Easy for us to operate.

Software Name:

Jinshan WPS 2003 official free full edition

Software size:


Update Time:



Create a new form, enter content, or a table that has already been edited. We need to filter out the contents of the table.

The following figure is what I input, if we need to filter out part of the content. Click "AutoFilter"

Click on the data bar, and then select Automatic Filter, the whole column of the first line appears a triangle, click the triangle Drop-down, you will see a dialog box, click All, the following can be directly filtered, click above the evaluation value, below the average, and so on after confirmation can be directly screened out the required content.

If the above settings do not meet the need to filter the content, you can click on the right "digital screening",

In the following figure, in the dialog box below, select the range you want to filter, there are many options to filter, and, depending on your needs, enter the range of the filter, and pay attention to selecting "and", "or". There are two selection range inputs.

By doing the above, we are able to filter out the desired range of content.

Attention matters

Notice the difference between "and" and "or".

The above is the WPS table how to operate the selection format method Introduction, hope to be helpful to everybody!

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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: and provide relevant evidence. A staff member will contact you within 5 working days.