How to Use WPS Filter on Android

Use WPS Filter on Android through 3 how-to topics, including turning Filter on or off, filtering by criteria, and exporting filtered results; 2 topics are free and 1 is membership-related.

How-to Index

How-to Guide

1. Turn Filter On or Off

Entry points:

• Entry 1: Tools > Data > Filter
• Entry 2: Select rows or columns, then tap Filter in the floating toolbar

1. Open the spreadsheet you want to work with.
2. Tap Tools at the bottom.
3. Select the Data tab.
4. Tap Filter.
5. When filter arrows appear next to the column headers, Filter is on.
6. To turn it off, tap Filter again.

Success Criteria

• Interface result: Filter dropdown arrows appear or disappear next to the column headers.
• What you can do next: You can tap a header arrow to set filter conditions.

Tips While Using

• Common mistake: If the wrong data range or header row is selected, the result may not match your expectation.
• Environment note: A clear header row makes filtering easier to use.

2. Filter by Criteria

Entry point: Tap the filter dropdown arrow in a column header

1. Turn Filter on first.
2. Tap the dropdown arrow in the column you want to filter.
3. Choose a filter method in the menu.
4. To filter by cell content, switch to Content.
5. To filter by color, switch to Color.
6. To filter by custom rules, switch to Condition.
7. Confirm the settings and review the filtered result.

Success Criteria

• Interface result: Only rows that match the selected criteria remain visible.
• What you can do next: You can change the criteria, switch filter methods, or remove the filter.

Tips While Using

• Common mistake: Filtering hides rows instead of deleting them.
• Environment note: Large datasets may take longer to process.

3. Export Filtered Results

Entry point: Tap the filter dropdown arrow in a column header

1. Turn Filter on and apply the filter conditions you need.
2. Tap the dropdown arrow in the target column.
3. Tap Export in the filter menu.
4. Choose Export Filter Results or Export Count.
5. Follow the on-screen prompts to finish the process.

Success Criteria

• Interface result: Export options are available and the result output or count is completed.
• What you can do next: You can adjust the filter and export again.

Tips While Using

• Membership note: This topic is membership-related. Check the membership indicator before use.
• Common mistake: Exporting before the filter conditions are fully set may produce unexpected results.
• Environment note: It is helpful to keep the device online when account status needs to be checked.