Use WPS Filter through 3 how-to topics, including turning Filter on or off, filtering by criteria, and exporting filtered results; 2 topics are free and 1 topic is membership-related.
How-to Index
| # | Topic | Membership |
|---|---|---|
| 1 | 1. Turn Filter On or Off | Free |
| 2 | 2. Filter by Criteria | Free |
| 3 | 3. Export Filtered Results | WPS Premium |
How-to Guide
1. Turn Filter On or Off
Entry point: Method 1: bottom Tools tab → Data → Filter; Method 2: row and column floating menu bar → Filter
- Select the data range you want to filter.
- Tap the bottom Tools tab, then tap Data.
- Tap Filter.
- Check whether filter drop-down arrows appear next to each column header.
- To turn Filter off, tap Filter again.
Success Criteria
- UI state: Filter drop-down arrows appear or disappear next to each column header.
- Next actions: You can tap a column header arrow to continue setting filter criteria.
Tips While Using
- Common mistakes: If you do not select the data range first, the filter range may not match your expectation.
- Environment limits: It is recommended that the data range include a clear header row.
2. Filter by Criteria
Entry point: tap the filter drop-down arrow next to a column header
- Turn on Filter first.
- Tap the drop-down arrow for the column you want to filter.
- In the filter menu, choose a filtering method.
- Switch between Content, Color, or Condition as needed.
- Confirm the setting and review the visible rows that match the criteria.
Success Criteria
- UI state: Only rows that match the current criteria remain visible in the sheet.
- Next actions: You can continue changing criteria, switch filter methods, or clear the filter.
Tips While Using
- Common mistakes: If you choose the wrong field, the filtered result may not be accurate.
- Environment limits: Filtering a large dataset may take some processing time.
3. Export Filtered Results
Entry point: tap the filter drop-down arrow next to a column header → Export
- Tap the drop-down arrow for the column you want to filter.
- In the filter menu, tap Export.
- Choose Export Filter Results to export the result to a new file, or choose Export Count to count matching items quickly.
- Follow the on-screen prompts to finish the process.
Success Criteria
- UI state: Export-related options are available, and the result output or count is completed.
- Next actions: You can open the new file to review the exported result or continue adjusting filter criteria.
Tips While Using
- Common mistakes: If you export before completing the filter, the output may not match the target data.
- Membership: This topic is membership-related. Check the membership indicator before use.
- Environment limits: Keep the app running normally and allow time for the export process.