How to Use WPS Filter on macOS

Use WPS Filter on macOS with 6 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.
• Next action available: you can continue filtering by column.

Tips While Using

• Common mistake: if the target data range is not selected first, filtering may not be applied as expected.

2. Turn on Filter from the right-click menu

Feature entry: right-click a cell → Filter drop-down menu → Filter

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

Success Criteria

• Interface result: drop-down arrows appear in the header row.
• Next action available: you can open a header arrow and set filter conditions.

Tips While Using

• Common mistake: if you right-click outside the target data range, the command may not match the intended task.

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 conditions in the dialog box.
4. Click OK.

Success Criteria

• Interface result: the Advanced Filter dialog opens and the conditions are applied.
• Next action available: you can review the filtered results that match the conditions.

Tips While Using

• Common mistake: incomplete condition settings can lead to unexpected results.

4. Turn on Advanced Filter from the right-click menu

Feature entry: right-click a cell → Filter drop-down menu → Advanced Filter

1. Select any cell in the data range.
2. Right-click the selected cell.
3. Click Advanced Filter in the filter drop-down menu.
4. Set the filter conditions in the dialog box.
5. Click OK.

Success Criteria

• Interface result: the advanced filter takes effect.
• Next action available: you can continue checking the filtered data.

Tips While Using

• Common mistake: if the data range does not have clear headers, it is harder to confirm filtering conditions.

5. Turn on Filter from the Home tab

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

1. Select any cell in the data range.
2. Click Data Processing on the Home tab.
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.
• Next action available: you can continue filtering data by column.

Tips While Using

• Common mistake: when switching between tabs, it is easy to click a different data-processing command by mistake.

6. Turn on Advanced Filter from the Home tab

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

1. Select any cell in the data range.
2. Click Data Processing on the Home tab.
3. Open the Filter drop-down menu.
4. Click Advanced Filter.
5. Set the filter conditions in the dialog box.
6. Click OK.

Success Criteria

• Interface result: advanced filter results appear in the current data range.
• Next action available: you can continue copying or reviewing the visible filtered data.

Tips While Using

• Common mistake: if the data range is not confirmed before filtering, the results may not be accurate.