When using WPS Filter on iOS, common questions usually involve the feature entry, filtered results, and membership-based export options; this FAQ includes 4 common questions and 4 glossary terms.
FAQ
Why can’t I find the Filter button?
- Make sure you opened a spreadsheet file rather than another file type.
- Select a data range that includes a header row.
- Tap Tools, then open Data and check whether Filter is available.
- If it still does not appear, update WPS Office to the latest version and try again.
Does filtering delete my data?
- Filtering only hides rows that do not match the criteria. It does not delete the original data.
- You can change the filter criteria or turn Filter off to show all rows again.
- If you want to remove data permanently, edit the sheet separately after confirming the content.
Why are only some rows copied after I filter data?
- When you copy data in a filtered state, only visible rows are usually copied.
- If you want to copy all data, turn Filter off first.
- Before copying, check whether the current filter criteria are still active.
Why can’t I use Export Filter Results?
- Make sure you have already applied a filter and opened the filter menu from the column header.
- Check whether the export-related options show a membership indicator.
- If your current account does not include the required membership benefits, subscribe first and then try again.
- If the feature is already available on your account but still does not work, sign in again and retry.
Glossary
| Term | Definition |
|---|---|
| Filter | An action that shows rows matching specified criteria and hides the others. |
| Header row | The top row of a data range that identifies each column and usually contains the filter arrows. |
| Condition-based filtering | A filtering method that narrows data with preset or custom rules. |
| Export Count | A feature that quickly counts the number of items in the current filtered result. |