WPS Hide Rows and Columns on iOS FAQ

Last updated:July 20, 2026

When using Hide Rows and Columns, the most common questions are about identifying hidden ranges, understanding whether data is affected, and handling multiple rows or columns at once; this FAQ covers 3 common questions.

FAQ

How can I tell whether a worksheet has hidden rows or columns?

  1. Check whether the row numbers or column labels are continuous.
  2. If the numbering jumps from row 3 to row 5, row 4 is usually hidden.
  3. The same logic applies to column labels when a letter is skipped.

Does hiding rows or columns affect formulas or references?

  1. No. Hiding only changes what is visible in the current worksheet view.
  2. The data still remains in the worksheet.
  3. Formula references and calculation results continue to work.

Can I hide multiple rows or columns at the same time?

  1. Yes. In edit mode, drag to select multiple targets.
  2. Select multiple rows or multiple columns together.
  3. Then use More Actions → Hide Row/Column to hide them in one step.

Glossary

TermDefinition
Hide Row/ColumnTemporarily removes selected rows or columns from the current worksheet view without deleting the data inside them.
UnhideShows rows or columns that were previously hidden in the worksheet.
Floating row or column toolbarA quick action toolbar that appears after you select a row number or column label and provides editing commands.