How to Hide Rows and Columns in WPS on macOS

Use Hide Rows and Columns through 4 how-to topics, all available without membership; choose a topic from the index and follow the steps to complete the task.

How-to Index

How-to Guide

1. Hide Rows

Entry: Select row headers → Right-click menu → Hide

1. Click the row header you want to hide to select the entire row.
2. To select multiple rows, hold Cmd and continue selecting other row headers.
3. Right-click within the selected row header area.
4. Select Hide.
5. The selected rows are hidden, and a double-line marker appears between row headers.

Success Criteria

• Visual result: The target rows are no longer visible.
• Next action available: You can continue editing other visible cells.
• No data loss: The hidden row data remains in the worksheet.

Tips While Using

• Common mistake: If you select only cells instead of the full row header, the right-click menu may be different.
• Environment note: This action must be performed in a worksheet.

2. Hide Columns

Entry: Select column headers → Right-click menu → Hide

1. Click the column header you want to hide to select the entire column.
2. To select multiple columns, hold Cmd and continue selecting other column headers.
3. Right-click within the selected column header area.
4. Select Hide.
5. The selected columns are hidden, and a double-line marker appears between column headers.

Success Criteria

• Visual result: The target columns are no longer visible.
• Next action available: You can continue viewing and editing other columns.
• No data loss: The hidden column data remains in the worksheet.

Tips While Using

• Common mistake: If you select only cells inside a column instead of the column header, you may not hide the full column directly.

3. Unhide

Entry: Select the adjacent rows or columns on both sides of the hidden area → Right-click menu → Unhide

1. Find the hidden area marked by a double line.
2. To restore hidden rows, select the adjacent row headers on both sides of the hidden rows.
3. To restore hidden columns, select the adjacent column headers on both sides of the hidden columns.
4. Right-click the selected area.
5. Select Unhide.
6. The hidden rows or columns appear again.

Success Criteria

• Visual result: The previously hidden rows or columns are visible again.
• Next action available: You can continue editing the restored content.

Tips While Using

• Common mistake: If you select only one side of the hidden area, the target rows or columns may not be restored.

4. Unhide All

Entry: Click the Select All button in the top-left corner → Right-click menu → Unhide

1. Click the Select All button at the intersection of row headers and column headers.
2. Right-click any row header or column header.
3. Select Unhide.
4. All hidden rows and columns in the current worksheet are restored.

Success Criteria

• Visual result: All hidden rows and columns in the worksheet are visible again.
• Next action available: You can continue editing, reviewing, or printing the full worksheet.

Tips While Using

• Common mistake: If the whole worksheet is not selected first, the action applies only to the current selection.