Hide Rows and Columns in WPS on iOS FAQ

When using Hide Rows and Columns in WPS on iOS, common questions usually involve identifying hidden content, confirming whether data stays intact, and handling multiple rows or columns at once; this FAQ includes 3 common questions and a glossary.

FAQ

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

1. Check whether the row numbers or column headers are continuous.
2. If the row numbers jump from one row to another, the missing row may be hidden.
3. If the column headers skip letters, the missing columns may also be hidden.
4. If you need to confirm it, select the adjacent rows or columns and open Manage Hidden Rows and Columns.

Does hiding rows or columns keep the data and formulas?

1. Yes. Hiding rows or columns only changes what is shown in the current view.
2. The original worksheet data remains in place.
3. Formula references and calculations normally continue to work.
4. If you want to show the content again, use Manage Hidden Rows and Columns to unhide it.

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

1. Yes.
2. Long-press and drag to select multiple target rows or columns.
3. Then go to Tools > Home > Rows & Columns > Hide.
4. All selected rows or columns will be hidden together.

Glossary