WPS Filter on iOS FAQ

Last updated:July 20, 2026

When using Filter, the most common questions fall into 3 areas: filter range, result display, and restoring data; this section answers 3 common questions.

FAQ

Why don’t I see drop-down arrows after I tap Filter?

  1. Make sure you are working in a spreadsheet file and have selected the rows, columns, or cell range you want to filter.
  2. Check whether the selected range includes a header row instead of only an unrelated single cell.
  3. Tap Filter again in the bottom toolbar and check whether arrows appear next to the column headers.

Can data in hidden rows or columns be filtered?

  1. If the current filter range contains hidden rows or columns, that data is not shown in the filter results.
  2. If you want to filter the full dataset, unhide the related rows or columns first.
  3. Run the filter again, then review the results by content, color, or search condition.

Does filtering delete the original data?

  1. No. Filtering only hides rows that do not match the current condition.
  2. If you want to restore all data, clear the current filter conditions or turn Filter off.
  3. After that, the original records appear in the worksheet again.

Glossary

TermDefinition
FilterA feature that shows rows matching specific conditions and hides the others.
Ascending/DescendingA way to reorder the current column from low to high, high to low, or in alphabetical order.
By ContentFiltering data based on text, numbers, or matching values in cells.
By ColorFiltering marked data based on cell fill color.
Visible to everyoneA setting in a collaborative worksheet that controls whether the current filtered result is visible only to you or also to other viewers.