How to Use WPS Filter on Windows

This how-to guide includes 2 operation topics for WPS Filter, both available directly in the current spreadsheet, with 2 free items and 0 membership-related items.

How-to Index

How-to Guide

1. Add a Filter Condition

Entry: Toolbar → Filter → Filter Condition

1. Open the target spreadsheet and click Filter on the toolbar.
2. Click Filter Condition and choose the field you want to filter.
3. Set the condition type, such as contains, equals, greater than, or less than.
4. Enter or select the filter value, and the records are filtered in real time.
5. If needed, click Lock Now to keep the current view setting.

Success Criteria

• Interface result: Only the records that match the condition remain visible in the table.
• What you can do next: You can continue editing the condition, reviewing the result, or removing the filter.

Tips While Using

• Common mistake: If some rows seem to disappear after filtering, they are usually hidden rather than deleted.
• Environment note: The target field should contain recognizable data so the filter can return accurate results.

2. Set Multiple Filter Conditions

Entry: Toolbar → Filter → Add conditions again

1. Add and finish the first filter condition.
2. Click Filter Condition again to add a second condition.
3. In the upper-right area of the filter panel, choose the logic mode: Meet all conditions or Meet any condition.
4. Add more conditions if needed.
5. Review the filtered result after the conditions are combined.

Success Criteria

• Interface result: Records are shown according to the combined result of multiple conditions.
• What you can do next: You can switch the logic mode or remove one condition and review the result again.

Tips While Using

• Common mistake: If the result becomes empty after stacking conditions, check the field, condition type, and logic mode first.
• Environment note: The more conditions you add, the narrower the result becomes, so it helps to add them step by step.