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

How to filter out the content you want in wps

WBOY
WBOYforward
2024-02-07 14:39:071910browse

php editor Strawberry will introduce to you today how to filter out the content you want in WPS. WPS is a powerful office software, and its filtering function can help us quickly find the information we need. Whether you are filtering data in an Excel table or filtering specific content in a Word document, you can do it with some simple operations. Next, let’s take a look at the specific steps and techniques to make you more comfortable when using WPS!

How to filter out the content you want in wps

How to filter out the content you want with wps

1. First use WPS to open the Excel table to be operated.

How to filter out the content you want in wps

#2. After opening, select any cell containing a title.

How to filter out the content you want in wps

#3. Then click the filter icon in the Home tab to turn on filtering.

How to filter out the content you want in wps

#4. Then click the inverted triangle after the title you want to search for. Here, take age as an example.

How to filter out the content you want in wps

#5. Now select the content to be filtered, here we take 20 as an example, and then click OK.

How to filter out the content you want in wps

#6. In this way, you can filter out the data with an age of 20.

How to filter out the content you want in wps

#7. You can also search. For example, if you want to filter Zhang San’s data, search for Zhang San in the search bar above, and then click OK.

How to filter out the content you want in wps

#8. In this way, only all the data named Zhang San will be filtered out.

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!

Statement:
This article is reproduced at:chromezj.com. If there is any infringement, please contact admin@php.cn delete