This FAQ covers 3 common questions about hidden-state recognition, data impact, and batch actions when you hide rows and columns in WPS on Android.
FAQ
How can I tell whether a worksheet has hidden rows or columns?
- Check whether the row numbers or column headers are continuous.
- If the row numbers jump from Row 3 to Row 5, Row 4 is usually hidden.
- If the column headers skip a position, a hidden column may be between them.
Can hidden rows or columns still be referenced in formulas?
- Yes. Hiding changes only the current display.
- The cell data in hidden rows or columns remains in the worksheet.
- Formula references and calculations usually continue to work after hiding.
How to hide multiple rows or columns at once in WPS on Android?
- Long-press and drag to select multiple target rows or columns.
- Go to Tools → Home → Rows & Columns.
- Tap Hide to process all selected rows or columns at once.
Glossary
| Term | Definition |
|---|---|
| Row number | The numbered marker on the left side of a worksheet that identifies each row. |
| Column header | The lettered or labeled marker at the top of a worksheet that identifies each column. |
| Unhide | The action of restoring a hidden row or column so it becomes visible again. |