How to Use WPS Filter on Windows

Use WPS Filter through 4 how-to topics, all available without membership; choose a topic from the index and follow the entry path and steps below.

How-to Index

How-to Guide

1. Turn on Filter from the Ribbon

Feature entry: Data tab → Filter drop-down menu → Filter

1. Select any cell in the data range.
2. Click Filter on the Data tab.
3. Check whether drop-down arrows appear in the header row.

Success Criteria

• Interface result: Drop-down arrows appear in the header row.
• What you can do next: You can continue filtering by column.

Tips While Using

• Common mistake: If the target data range is not selected clearly, the filter may not be applied as expected.

2. Turn on Filter from the Right-Click Menu

Feature entry: Right-click any cell → Filter drop-down menu → Filter

1. Select any cell in the data range.
2. Right-click the selected cell to open the shortcut menu.
3. Open the Filter drop-down menu.
4. Click Filter.
5. Check whether drop-down arrows appear in the header row.

Success Criteria

• Interface result: Drop-down arrows appear in the header row.
• What you can do next: You can set filter conditions from the header arrows.

Tips While Using

• Common mistake: If you right-click outside the target data range, the shortcut menu may not show the expected entries.

3. Turn on Advanced Filter from the Ribbon

Feature entry: Data tab → Filter drop-down menu → Advanced Filter

1. Select any cell in the data range.
2. Click Advanced Filter on the Data tab.
3. Set the filter criteria in the dialog box.
4. Click OK.

Success Criteria

• Interface result: The Advanced Filter dialog box opens and accepts your criteria.
• What you can do next: The worksheet shows results based on the conditions you set.

Tips While Using

• Common mistake: Incomplete criteria can produce results that do not match your expectation.

4. Turn on Advanced Filter from the Right-Click Menu

Feature entry: Right-click any cell → Filter drop-down menu → Advanced Filter

1. Select any cell in the data range.
2. Right-click the selected cell.
3. Open the filter-related menu.
4. Click Advanced Filter.
5. Set the filter criteria in the dialog box.
6. Click OK.

Success Criteria

• Interface result: The Advanced Filter dialog box opens and applies the criteria.
• What you can do next: You can adjust the criteria again or review the filtered data.

Tips While Using

• Common mistake: If the data range or criteria range is unclear, you may need to adjust the filter settings again.