How to Hide Rows and Columns in WPS on iOS

Use Hide Rows and Columns in WPS on iOS through 2 how-to topics; 2 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Hide rows and columns

Feature entry: Tools → Home → Rows & Columns → Hide

1. Open a WPS spreadsheet file and select the row number or column header that you want to hide.
2. Tap Tools at the bottom.
3. Open the Home menu and tap Rows & Columns.
4. Tap Hide in the expanded options.
5. To hide multiple rows or columns, long press and drag the selection box to select multiple targets, then run the hide action.

Success Criteria

• Interface result: The selected row or column is no longer visible in the current worksheet.
• What you can do next: You can continue editing other cells or move on to managing hidden rows and columns.

Tips While Using

• Common mistake: Make sure you select the row number or column header instead of a regular cell range.
• Environment note: If the file is read-only, you may not be able to change the worksheet display structure.

2. Manage hidden rows and columns

Feature entry: Select the adjacent rows or columns around the hidden area → Tools → Home → Rows & Columns → Manage Hidden Rows and Columns

1. Select the rows or columns on both sides of the hidden area.
2. Tap Tools at the bottom.
3. Open the Home menu and tap Rows & Columns.
4. Tap Manage Hidden Rows and Columns in the expanded options.
5. Choose hidden rows or hidden columns as needed, then unhide one item or all items.

Success Criteria

• Interface result: The previously hidden rows or columns appear again, and the row numbers or column headers become continuous.
• What you can do next: You can continue editing the restored data area.

Tips While Using

• Common mistake: If you do not select the adjacent rows or columns around the hidden area first, the management range may not be identified correctly.
• Environment note: After content is restored, the original data and formula references remain unchanged.