How to Use WPS Filter on Windows

Use WPS Filter with 4 how-to topics, including turning on Filter and filtering data by condition; choose a topic from the How-to Index and follow the entry path and steps.

How-to Index

How-to Guide

1. Turn on Filter

Entry path: 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 drop-down arrows appear in each column header.
4. You can also press Ctrl + Shift + L to turn Filter on quickly.

Success Criteria

• Interface result: A drop-down arrow appears in each column header.
• What you can do next: You can click a column header arrow to set filter conditions.

Tips While Using

• Common mistake: If the selected range is not continuous, the filter range may be incomplete.
• Environment note: It is recommended to keep a clear header row so the columns can be recognized correctly.

2. Filter data by condition

Entry path: Click the drop-down arrow in a column header

1. Click the drop-down arrow in the target column header.
2. Choose a filtering method in the panel.
3. Select the items you want to show, or choose filter by color.
4. If needed, choose conditions such as equals, greater than, less than, or between.
5. Confirm the selection and review the filtered rows.

Success Criteria

• Interface result: Rows that do not match the condition are temporarily hidden.
• What you can do next: You can continue adding filters to other columns.

Tips While Using

• Common mistake: Clearing all items by mistake may leave no visible data in the current column result.
• Environment note: When multiple columns are filtered, the result reflects all active column conditions together.

3. Use the search box to filter faster

Entry path: 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 narrowed list of candidate items in the filter panel.
4. Select or clear the relevant items.
5. Confirm and review the filtered result.

Success Criteria

• Interface result: The filter panel shows only items or results related to the keyword.
• What you can do next: You can change the keyword or adjust the selected items again.

Tips While Using

• Common mistake: Entering a keyword without checking the selected items may produce an unexpected result.
• Environment note: The search box narrows the candidate list, but the final result still depends on the checked items.

4. Clear Filter

Entry path: Home tab → Filter; or column drop-down arrow → Clear Filter

1. To clear the filter in one column, click that column's drop-down arrow.
2. Select Clear Filter to restore the full data for that column.
3. To clear all filters, click Filter again to turn filtering off.
4. You can also press Ctrl + Shift + L to switch the filter state quickly.

Success Criteria

• Interface result: Hidden rows appear again, or the header drop-down arrows disappear.
• What you can do next: You can turn Filter on again and apply new conditions.

Tips While Using

• Common mistake: Turning filtering off before confirming the current result may interrupt your review flow.
• Environment note: After filtering is turned off, the current view no longer keeps the previous filter state active.