This FAQ covers 3 common questions about WPS Filter on Android, including visible ranges, hidden data, and restoring full results, plus a short glossary.
FAQ
Can data in hidden rows or columns be filtered?
- If the filter range includes hidden rows or columns, that data will not appear in the filter results.
- If you want that data to participate in filtering, unhide the related rows or columns first.
- Then turn filtering on again or reapply the filter and review the results.
Does filtering delete the original data?
- No. Filtering only hides rows that do not match the current conditions.
- You can change the filter conditions or turn filtering off to restore the full view.
- If you want to show all data again, clear the filter directly.
Why do I see fewer rows than expected after filtering?
- Check whether multiple conditions are active at the same time, such as content filters, color filters, or sorting.
- Check whether the filter range contains hidden rows or columns.
- In a collaborative spreadsheet, confirm whether the Visible to everyone setting matches your current viewing needs.
Glossary
| Term | Definition |
|---|---|
| Filter | An action that shows rows matching selected conditions and hides the rest. |
| Ascending/Descending | Sorting methods that arrange data from low to high, high to low, or in alphabetical order. |
| Filter by Color | A filtering method that shows target data based on visual markers such as cell fill color. |