How to Use WPS Filter on iOS

Use WPS Filter with 3 how-to topics: turn Filter on or off, filter by criteria, and export filtered results. Start from the How-to Index and follow the steps for the task you need.

How-to Index

How-to Guide

1. Turn Filter On or Off

Entry: Method 1 is Tools > Data > Filter. Method 2 is Filter in the floating row and column menu.

1. Select the rows and columns you want to filter. It is usually helpful to include the header row.
2. Tap Tools at the bottom.
3. Open Data and tap Filter.
4. When filter arrows appear next to the column headers, Filter is on.
5. To turn it off, tap Filter again.

Success Criteria

• Interface result: Filter arrows appear or disappear next to the column headers.
• What you can do next: Tap a filter arrow in any column to open the filter menu.

Tips While Using

• Common mistake: If the selected range does not include the full header area, the filter range may not match your expectation.
• Environment note: A clear header row makes later column filtering easier.

2. Filter by Criteria

Entry: Tap the filter arrow next to a column header.

1. Turn Filter on first.
2. Tap the drop-down arrow for the column you want to filter.
3. Select a filtering method in the pop-up menu.
4. To filter by content, choose Content and select or locate the target values.
5. To filter by color, choose Color.
6. To filter by rule, choose Condition and set a custom condition.
7. Confirm the setting and review the filtered rows.

Success Criteria

• Interface result: Only rows that match the current criteria remain visible.
• What you can do next: You can adjust the criteria, switch filtering methods, or clear the filter.

Tips While Using

• Common mistake: Filtering does not delete data. Rows that do not match are only hidden.
• Environment note: Large data sets may take more time to process.

3. Export Filtered Results

Entry: Tap the filter arrow next to a column header.

1. Complete the current filter for one or more columns.
2. Tap the filter arrow for the column you want to use.
3. In the pop-up menu, tap Export.
4. Select Export Filtered Results to export the current results to a new document, or select Export Count to count the filtered items.
5. Follow the on-screen prompts to finish the action.

Success Criteria

• Interface result: You can see the export result entry or the count result.
• What you can do next: Save the new document or return to the original sheet and adjust the filter criteria.

Tips While Using

• Membership note: This topic is membership-related. Check the membership indicator before use.
• Common mistake: If you export before applying the intended filter, the result may not match your target data.