How to Filter in Spreadsheet in WPS on iOS

Use Filter in Spreadsheet through 1 how-to topic, including adding a filter condition; 1 item is available without membership and 0 items are membership-related.

How-to Index

How-to Guide

1. Add a filter condition

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

1. Tap the Filter button in the bottom toolbar.
2. In the pop-up window, select Filter.
3. Tap Add Filter Condition.
4. Select the field you want to filter and choose the filter rule.
5. If needed, add more rules and choose whether the result should match All Conditions or Any Condition.
6. After setup, the filtered result takes effect immediately.

Success Criteria

• Interface result: only the rows that match the selected filter conditions remain visible in the data table.
• Next action available: you can continue adjusting fields, rules, or adding more conditions.
• No side effect: the original data is not deleted or modified.

Tips While Using

• Common mistake: if you choose the wrong field first, the filtered result may not match what you expect.
• Environment note: in a shared view, the filter conditions are visible to collaborators.