When using WPS Filter on macOS, common questions usually involve copying filtered results, removing filters, and applying conditions across multiple columns; this FAQ includes 3 common questions and a glossary.
FAQ
How do I copy only visible cells after filtering?
- Complete the filter operation you need.
- Select the visible filtered result range.
- Copy the selection. Hidden rows are not included with the visible results.
How do I remove a filter?
- Return to the worksheet where filtering is enabled.
- Click Filter again, or use the related clear filter command.
- Confirm that the previously hidden rows are visible again.
Can I apply filter conditions to multiple columns at the same time?
- Turn on filtering for the data range first.
- Open the drop-down arrow for each relevant header.
- Apply the needed conditions by column to narrow the results with multiple conditions.
Glossary
| Term | Definition |
|---|---|
| Filter | A feature that shows rows matching selected conditions and hides rows that do not match. |
| Advanced Filter | A filtering method that uses a dialog box for more specific conditions and more detailed data review. |
| Header drop-down arrow | The control that appears in a header cell after filtering is enabled and lets you choose filter conditions. |