Home>Article> How to filter out the content you want in wps

How to filter out the content you want in wps

藏色散人
藏色散人 Original
2020-12-02 11:29:20 13510browse

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.

How to filter out the content you want in wps

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.

How to filter out the content you want in wps

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.

How to filter out the content you want in wps

How to filter out the content you want in wps

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!

wps
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:How to add music in PR Next article:How to add music in PR