How to Filter in Spreadsheet in WPS on Android

Use spreadsheet filtering through 3 how-to topics, with 3 available without membership and 0 membership-related items; start from the How-to Index below.

How-to Index

How-to Guide

1. Add filter conditions

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

1. Open the data table you want to work with.
2. Tap Filter in the bottom toolbar.
3. In the pop-up panel, select Filter.
4. Tap Add Filter Condition.
5. Select the field you want to filter.
6. Choose the filter rule and finish the setup.
7. Review the updated results in the table.

Success Criteria

• On-screen result: Only records that match the current condition remain visible.
• What you can do next: You can continue to add, edit, or remove filter conditions.

Tips While Using

• Common mistake: If you set a rule before choosing the correct field, the result may not match what you expect.
• Environment note: Keep a network connection when you work with online shared data tables so results can refresh normally.

2. Combine multiple filter rules

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

1. Open the filter panel by following the path above.
2. Tap Add Filter Condition and set the first rule.
3. Add a second rule or more rules as needed.
4. Choose All Conditions or Any Condition for the rule relationship.
5. Return to the table and review the filtered result range.

Success Criteria

• On-screen result: Multiple rules take effect together, and the visible result changes with the selected relationship.
• What you can do next: You can keep adding rules or switch the relationship setting.

Tips While Using

• Common mistake: Confusing All Conditions with Any Condition can make the result set too narrow or too broad.

3. Understand filtered results and shared visibility

Entry path: A data table view with filters already applied

1. After you finish the filter setup, review the rows that remain visible.
2. Confirm that hidden records are only temporarily hidden.
3. If you are working in a shared view, let collaborators know that the current filter conditions are visible to them.
4. Clear or adjust the current filters when you need to show the full dataset again.

Success Criteria

• On-screen result: Filtering changes only the visible range, while the original data remains in the table.
• What you can do next: You can continue sharing the view, adjust conditions, or restore all records.

Tips While Using

• Common mistake: Treating filtered-out rows as deleted data.
• Environment note: Filter conditions in a shared view are visible to collaborators.