Common questions about WPS Filter on macOS mainly focus on collaboration visibility, reapplying filters, and missing filter arrows, with 3 high-frequency answers included below.
FAQ
Will the filters that I set in collaboration mode affect other collaborators?
- Open the current spreadsheet and make sure Filter is turned on.
- Check the filter panel for the setting related to making the filter visible to everyone.
- If you do not want to affect other collaborators, turn that option off before applying the filter.
- Ask collaborators to refresh the sheet and confirm whether each person sees the expected result.
How do I reapply all filter conditions?
- Open the spreadsheet and go to the Home tab.
- Click the drop-down arrow next to Filter.
- Select the option to reapply all filter conditions.
- Check whether the current results refresh based on the existing criteria.
Why are filter drop-down arrows missing in some columns?
- Check whether the data range contains blank rows or blank columns.
- Confirm whether the filter range was interrupted by those blanks.
- Keep the data range continuous, or use the related option to include data after blank rows when available.
- Turn on Filter again and check whether the header arrows appear.
Glossary
| Term | Definition |
|---|---|
| Filter | A way to show rows that meet selected criteria while hiding other rows from the current view. |
| Drop-down arrow | The control that appears in a column header after Filter is turned on and opens filter options. |
| Filter by condition | A filtering method that uses rules such as equal to, greater than, less than, or between. |
| Search box filtering | A way to narrow candidate items in the filter panel by entering keywords. |