WPS Filter on Windows FAQ covers 3 common questions about collaboration visibility, reapplying filter conditions, and missing filter arrows, plus a short glossary for key terms.
FAQ
Does the filter I set in collaborative mode affect other collaborators?
- Open the filter panel in the current spreadsheet.
- Check whether a shared visibility option such as making the filter visible to everyone is enabled.
- If you do not want the filter to affect other collaborators, turn that setting off before applying the filter.
How do I reapply all filter conditions?
- Open the Filter menu from the Home tab.
- Find the option related to reapplying all filter conditions.
- Click it and review whether the current data range refreshes under the existing conditions.
Why do some columns not show filter drop-down arrows?
- Check whether the data range contains empty rows or empty columns.
- Confirm whether the filter range is interrupted by those empty rows or columns.
- Keep the data range continuous, or use the related option to include data after empty rows when needed.
Glossary
| Term | Definition |
|---|---|
| Filter | A way to show rows that match selected conditions and hide rows that do not match them. |
| Drop-down arrow | The control that appears in a column header after filtering is turned on and opens the filter panel. |
| Filter by condition | A filtering method based on rules such as text, number, range, or other criteria. |
| Search box filtering | A way to type a keyword in the filter panel to narrow the list of candidate items quickly. |