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.
Jinshan WPS 2003 official free full edition
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.
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!