How to Use WPS Filter on macOS

Use WPS Filter in 3 topics: set filter conditions, switch condition logic, and remove filters to show all data; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Set Filter Conditions

Entry path: Toolbar → Filter → Add Condition

1. Open the target worksheet.
2. Click the Filter button in the toolbar.
3. Click Add Condition.
4. Select the field you want to filter.
5. Set the matching filter condition.

Success Criteria

• Interface result: The worksheet enters a filtered state and shows the added condition.
• Next action available: You can continue adding conditions or review the filtered results.

Tips While Using

• Common mistake: Adding a condition before checking the field content may return no results.
• Environment note: A worksheet with clear headers makes field selection easier.

2. Switch Condition Logic

Entry path: Toolbar → Filter → Condition Logic

1. Add more than one filter condition.
2. Open the condition area.
3. Choose Match All Conditions or Match Any Condition based on your goal.
4. Check whether the filtered result matches what you want to review.

Success Criteria

• Interface result: The result list updates after the logic is changed.
• Next action available: You can keep adjusting fields or switch the logic again.

Tips While Using

• Common mistake: Mixing up all-condition and any-condition logic can produce an unexpected number of results.

3. Remove Filters and Show All Data

Entry path: Toolbar → Filter → Delete Filter

1. Open the worksheet that already has a filter applied.
2. Click Filter in the toolbar.
3. Choose to delete the filter or remove the current filter condition.
4. Confirm that all records are visible again.

Success Criteria

• Interface result: Previously hidden rows appear again.
• Next action available: You can set a new filter or continue editing the worksheet.

Tips While Using

• Common mistake: Removing only one condition instead of the full filter may leave some rows hidden.