How to Use WPS Filter on Android

Use WPS Filter on Android with 3 how-to topics, including turning Filter on or off, filtering by condition, and exporting filtered results.

How-to Index

How-to Guide

1. Turn Filter On or Off

Entry: Method 1: Tools → Data → Filter; Method 2: Row and column floating menu bar → Filter

1. Open the spreadsheet file you want to work with.
2. Tap Tools at the bottom and open the Data tab.
3. Tap Filter.
4. Filter drop-down arrows appear next to the column headers.
5. To turn Filter off, tap Filter again.
6. You can also select the target rows or columns first, open the floating menu bar, and tap Filter.

Success Criteria

• On-screen result: Filter arrows appear next to column headers, or disappear after you turn Filter off.
• Next action available: You can tap any filter arrow to continue setting conditions.

Tips While Using

• Common mistake: If the header area is not selected clearly, it may be harder to confirm the filter range.
• Environment note: A clear header row helps identify each field correctly.

2. Filter by Condition

Entry: Tap the filter arrow in a column header

1. Turn on Filter first.
2. Tap the drop-down arrow next to the column you want to filter.
3. Choose a filter method in the menu.
4. For content-based filtering, select Content and check or clear the items you want.
5. For color-based filtering, select Color.
6. For rule-based filtering, select Condition and set a custom rule.
7. Confirm the setting and review the visible rows that remain.

Success Criteria

• On-screen result: Rows that do not match are hidden, while matching rows remain visible.
• Next action available: You can switch to another column or adjust the current condition.

Tips While Using

• Common mistake: Filtering hides rows but does not delete the original data.
• Environment note: Large data sets may take more time to process.

3. Export Filtered Results

Entry: Tap the filter arrow in a column header → Export

1. Finish the filter setup for the target column first.
2. Tap the drop-down arrow for the filtered column.
3. Tap Export in the filter menu.
4. Select Export filtered results to export the current filtered data to a new file, or select Export count to count the filtered entries quickly.
5. Follow the on-screen prompts to finish the remaining steps.

Success Criteria

• On-screen result: Export-related options are visible, and you can open the result page or count result.
• Next action available: You can save the exported file or adjust the filter and export again.

Tips While Using

• Membership note: This topic is membership-related, so check the membership indicator before use.
• Common mistake: If you export before finishing the filter, the result may not match what you expect.