How to Hide Rows and Columns in WPS on iOS

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

How-to Index

How-to Guide

1. Hide Rows and Columns

Entry path: Tools → Home → Rows & Columns → Hide

1. Open your WPS spreadsheet file and select the row numbers or column headers that you want to hide.
2. Tap the Tools tab at the bottom.
3. Open the Home menu and tap Rows & Columns.
4. Tap Hide in the expanded options.
5. If you want to hide multiple rows or columns, long-press and drag to select multiple targets first, then apply the hide action.

Success Criteria

• On-screen result: The selected row numbers or column headers disappear from the current view.
• What you can do next: You can continue editing, scrolling, and saving the spreadsheet.
• No unwanted changes: The hidden data remains in the worksheet.

Tips While Using

• Common mistake: If you select cell content instead of row numbers or column headers, you may not hide the intended rows or columns.
• Environment note: The spreadsheet needs to be in an editable state.

2. Manage Hidden Rows and Columns

Entry path: 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 the Tools tab at the bottom.
3. Open the Home menu and tap Rows & Columns.
4. Tap Manage Hidden Rows and Columns.
5. Choose whether to manage hidden rows or hidden columns, or use options such as unhide one item or unhide all.

Success Criteria

• On-screen result: The hidden row and column management panel opens with related options.
• What you can do next: You can restore one hidden item or all hidden content as needed.
• No unwanted changes: Other unselected data areas remain unchanged.

Tips While Using

• Common mistake: If you do not select the adjacent rows or columns correctly, the management entry may not open as expected.
• Environment note: If the spreadsheet is read-only, editing actions may be unavailable.