Common questions about WPS Filter on iOS usually involve where to find the feature, how filtered rows behave, and how export works. This FAQ covers 4 common questions to help you finish the task faster.
FAQ
Why do I not see filter arrows after turning Filter on?
- Make sure you selected a data range that includes the header row.
- Open Tools > Data > Filter again and check whether arrows appear in the header row.
- If they still do not appear, reselect the range and turn Filter on again.
Does filtering delete my data?
- No. Filtering only hides rows that do not match the current criteria.
- You can change the filter criteria or turn Filter off to view the full data set again.
- If you want to keep a separate result, use the filtered-result export feature.
Why does copying data only copy some rows after I filter?
- When a filter is active, copy actions usually include only the visible rows.
- If you need to copy all rows, turn Filter off first.
- Then copy the data again.
How do I export filtered results on iPhone or iPad?
- Apply the filter you need first.
- Tap the filter arrow next to the column header and tap Export.
- Select Export Filtered Results or Export Count.
- If a membership prompt appears, make sure your current account has the required benefit.
Glossary
| Term | Definition |
|---|---|
| Filter | A way to show rows that match specific criteria while hiding other rows. |
| Conditional filter | A filter based on comparison rules or custom conditions, such as greater than, less than, or contains. |
| Color filter | A filter based on visual markers such as cell fill color. |
| Export filtered results | A feature that outputs the current filtered result to a new document or generates a count result. |