How to Use WPS Filter on macOS

Use WPS Filter on macOS across 4 how-to topics, all available without membership; start from the How-to Index and follow the entry path and steps for each task.

How-to Index

How-to Guide

1. Turn on Filter

Entry: Home tab → Filter

1. Select any cell in the data range, or select the full table first.
2. Click Filter on the Home tab.
3. Check whether a filter drop-down arrow appears in each column header.
4. You can also press Shift + Command + L to turn on Filter quickly.

Success Criteria

• Interface result: A filter drop-down arrow appears in each column header.
• Next action available: You can click a header arrow to set filter criteria.

Tips While Using

• Common mistake: If the selected range is incomplete, the filter range may not cover all data.
• Environment note: A clear header row helps the filter work as expected.

2. Filter Data by Condition

Entry: Click the drop-down arrow in the target column header

1. Click the drop-down arrow in the target column.
2. Choose a filtering method in the panel.
3. To filter by selected values, check the items you want to keep visible.
4. To filter by color, choose the target cell fill color.
5. To filter by condition, choose a rule such as equal to, greater than, less than, or between.
6. Confirm the criteria and review the rows that remain visible.

Success Criteria

• Interface result: Rows that do not match the criteria are hidden.
• Next action available: You can add filters in other columns or adjust the current one.

Tips While Using

• Common mistake: Too many conditions may return no visible rows, so review each condition one by one.
• Environment note: Filter by color requires recognizable cell colors in the target column.

3. Use the Search Box for Quick Filtering

Entry: Column header drop-down arrow → Search box

1. Click the drop-down arrow in the target column.
2. Enter a keyword in the search box.
3. Review the matching items shown by the filter panel.
4. Check or clear the items you want.
5. Confirm the selection to apply the result.

Success Criteria

• Interface result: Only matching candidate items or result rows remain visible.
• Next action available: You can revise the keyword or adjust the checked items.

Tips While Using

• Common mistake: An incomplete keyword may miss the target item.
• Environment note: Search results depend on the actual text stored in the current column.

4. Clear Filters

Entry: Home tab → Filter (click again to turn it off) / Column drop-down arrow → Clear Filter

1. To clear a filter in one column, click that column’s drop-down arrow.
2. Select Clear Filter to restore the full display for that column.
3. To clear all filters, click Filter again to exit filter mode.
4. You can also press Shift + Command + L to toggle filter mode quickly.

Success Criteria

• Interface result: Hidden rows reappear, or the filter state returns to normal.
• Next action available: You can apply new filter criteria or continue editing the sheet.

Tips While Using

• Common mistake: Clearing one column does not remove filters that are still active in other columns.
• Environment note: In multi-column filtering, check each column to confirm that all filters are cleared.