When you use Hide Rows and Columns in WPS on iOS, common questions usually involve hidden-state indicators, data retention, and batch actions; this FAQ includes 3 common questions and 3 glossary terms.
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 letter or label, there is usually a hidden column in between.
Can data in hidden rows or columns still be referenced?
- Yes. Hiding only changes what is visible in the worksheet.
- The data in hidden cells remains in the worksheet.
- Related formulas and calculation results usually continue to work normally.
Can I hide multiple rows or columns at one time?
- Yes. Long press and drag the selection box first.
- Select multiple target rows or columns.
- Then go to Tools → Home → Rows & Columns → Hide to hide them in one action.
Glossary
| Term | Definition |
|---|---|
| Row number | The numeric label on the left side of a worksheet that identifies each row. |
| Column header | The letter or label at the top of a worksheet that identifies each column. |
| Unhide | The action of showing rows or columns that were previously hidden in the current worksheet again. |