How to filter out the content you want in wps

How to filter content in wps: First select a row in the wps table; then find "AutoFilter" in the "Start" menu and click it; then click the small arrow and filter all data in the column selected by the arrow ;Finally, use keywords to perform batch filtering.

The operating environment of this tutorial: Windows7 system, Dell G3 computer, WPS Office Excel2013 software.

1. First select a row, such as the title row, then find "AutoFilter" in the "Start" menu and click it. At this time, a row of small drop-down arrows will appear in the selected title row.

2. Click the small arrow to filter all the data in the column selected by the arrow. You can select single or multiple selections. In addition, there are other things that are easily overlooked. A "text filter" content (or if it is data, a "numeric filter" will appear) can be batch filtered using keywords. At this time, make a single selection, and then confirm it. You can see the prompt below to filter out how many records from how many options, which is convenient for simple statistics.

The above is the detailed content of How to filter out the content you want in wps. For more information, please follow other related articles on the PHP Chinese website!