WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


Quickly filter classified data

Uploaded time: August 27, 2021 Difficulty Beginner

Quickly filter classified data

Quickly filter classified data

How to quickly extract data of a certain category from a large amount of data? The filtering feature of WPS Office can help us to do it quickly.

Take this table as an example. How are we going to filter out the data of New York?

1. Select any cell in the list.

2. Click the Home tab.

3. Click the AutoFilter drop-down button or use the shortcut key CTRL+Shift+L to set. Then the data list will enter the filtering state.


4. Click the gray inverted triangle arrow in the header cell of Branch, and only check the New York label.

Now the list will quickly filter out all the data on New York.

We can also do digital filtering quickly with this filtering feature. For example, we now want to extract data information with a total amount larger than $6000.

1. Click the gray inverted triangle arrow in the header cell of Lump sum.

2. Click Number Filter, and select the Greater Than command.

3. Then enter 6000 in the pop-up dialog box.

4. Click OK to get the data information with a total amount larger than $6000.

If the table content has already been marked with different colors, we can also use Filter by color.

First, set up the filter, then expand the filter details, and select Filter by color. Select a color according to our needs, and then everything is done!

To cancel the filter, just click the AutoFilter button again.

Easy your work with WPS Spreadsheet like Microsoft Excel. What a practical feature! Did you get it?

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.