How to use the automatic filtering feature in WPS Spreadsheet

The filter provides a quick way to find and use data subsets in a scope or a table. When you filter a data table, the system temporarily hides some data. This way, you can focus on the data that you want to manage. To use the automatic filtering feature, perform the following steps:

Step 1: Select a cell in the data table that you want to filter, and tap the toolbar in the lower-left corner.

Step 2: In the expanded toolbar, tap View and turn on the Filter switch to enable the automatic filtering feature. (To disable the automatic filtering feature, turn off the Filter switch.)

Step 3: Tap the drop-down arrow for the column you want to filter. You can filter values of the column.

Step 4: You can also use other features provided by the filtering tool: Ascending, Descending, Customize, Clear Filter, Filter Duplicates, and Filter Unique Items.