How to Use WPS Filter on Android

This section includes 3 how-to topics, all available directly on Android, so you can choose a topic from the index and follow the steps in order.

How-to Index

How-to Guide

1. Add a filter condition

Entry: Bottom toolbar → Filter → Filter → Add Filter Condition

1. Open the spreadsheet file that you want to work with.
2. Tap Filter on the bottom toolbar.
3. In the pop-up panel, select Filter.
4. Tap Add Filter Condition.
5. Select the field that you want to filter.
6. Select the rule you need. The setting takes effect right away.

Success Criteria

• On-screen result: only the rows that match the current condition remain visible.
• What you can do next: you can add another rule or adjust the condition logic.

Tips While Using

• Common mistake: choosing the wrong field before setting the rule can lead to unexpected results.
• Environment note: open a spreadsheet with structured data first so fields can be filtered correctly.

2. Add multiple filter rules

Entry: Bottom toolbar → Filter → Filter → Add Filter Condition

1. Open the filter panel by following the steps above.
2. Tap Add Filter Condition and set the first rule.
3. Continue adding more filter rules.
4. Check that each rule uses the correct field and condition.
5. Review the filtered results in the sheet.

Success Criteria

• On-screen result: multiple rules are visible in the filter panel.
• What you can do next: you can keep editing rules or change the condition logic.

Tips While Using

• Common mistake: using repeated fields without checking each rule carefully can make the result harder to judge.
• Environment note: more rules usually narrow the result set, so it helps to confirm each rule before adding the next one.

3. Switch between all conditions and any condition

Entry: Bottom toolbar → Filter → Filter condition logic settings

1. Add at least two filter rules first.
2. Find the condition logic option in the filter settings.
3. Select All Conditions to require every rule to be met.
4. Or select Any Condition to show rows that meet at least one rule.
5. Review the updated results and confirm that the current logic matches your needs.

Success Criteria

• On-screen result: the visible results update after the condition logic changes.
• What you can do next: you can go back and adjust fields, rules, or the condition logic again.

Tips While Using

• Common mistake: not distinguishing between all conditions and any condition can cause a large change in the number of visible rows.
• Environment note: this action depends on having multiple filter rules already added.