How to Hide Rows and Columns in WPS on Android

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

How-to Index

How-to Guide

1. Hide rows or columns

Entry path: Floating row and column toolbar → More actions → Hide Row/Column

1. Open a spreadsheet file and select the row header or column header that you want to hide.
2. Open the floating row and column toolbar.
3. Tap More actions.
4. Select Hide Row/Column.
5. To hide multiple targets at once, drag to select multiple rows or columns before applying the command.

Success Criteria

• Interface result: The selected row or column is no longer visible in the current worksheet view.
• Next action available: You can continue editing visible areas or unhide the hidden section later.

Tips While Using

• Common mistake: If you select only cell content instead of the row header or column header, the row or column action may not appear as expected.
• Environment note: Make sure the sheet is in editing mode first.

2. Manage hidden rows or columns

Entry path: Select the adjacent rows/columns around the hidden area → Floating row and column toolbar → More actions → Unhide Row/Column

1. Find the adjacent rows or columns on both sides of the hidden area.
2. Select those adjacent rows or columns together.
3. Open the floating row and column toolbar and tap More actions.
4. Select Unhide Row/Column.
5. Confirm that the hidden rows or columns are visible again.

Success Criteria

• Interface result: The previously hidden rows or columns appear again in the worksheet.
• Next action available: You can continue editing the restored data or hide it again if needed.

Tips While Using

• Common mistake: If you do not select the adjacent rows or columns on both sides of the hidden area, the target section may not be restored correctly.
• Environment note: If several hidden areas exist, check for skipped row numbers or column letters first.