Feature Summary
The Hide Rows/Columns feature allows you to hide rows or columns that do not need to be displayed, making the spreadsheet cleaner. It is suitable for scenarios such as presentations, projections, and printing. After hiding, the data is still retained and calculations are not affected.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Operation Steps
Hide Rows
Feature Entry
Select row numbers → Right-click menu → Hide button
- Click the row number you want to hide to select the entire row (hold
Cmdto select multiple rows) - Right-click on the selected row numbers
- Select the Hide button in the pop-up menu
- The selected rows will be hidden, and a double-line indicator will appear between the row numbers

Hide Columns
Feature Entry
Select column letters → Right-click menu → Hide button
- Click the column letter you want to hide to select the entire column (hold
Cmdto select multiple columns) - Right-click on the selected column letters
- Select the Hide button in the pop-up menu
- The selected columns will be hidden, and a double-line indicator will appear between the column letters

Unhide
Feature Entry
Select adjacent rows/columns on both sides of the hidden rows/columns → Right-click menu → Unhide button
- Select the adjacent rows on both sides of the hidden row (e.g., if row 3 is hidden, you need to select both row 2 and row 4 simultaneously)
- Right-click on the selected row numbers
- Select the Unhide button in the pop-up menu
- The hidden rows/columns will be restored and displayed

Frequently Asked Questions
Q1: Will the result of a SUM formula change after hiding rows/columns?
- Solution: No. Hiding is only a visual concealment; the data in the rows/columns is still retained, and formula calculations are not affected. If you need to exclude certain data from calculations, please use conditional functions such as
SUMIF.
Q2: What should I do if the shortcut keys for hiding rows/columns do not work?
- Solution: Check if any other software is occupying the shortcut keys. The shortcut for hiding rows:
Cmd+9; the shortcut for hiding columns:Cmd+0.
Q3: Why can't I see where the hidden rows are?
- Solution: A double-line indicator will appear between the hidden rows/columns (e.g., if there is a double line between row numbers
2and5, it means rows 3 and 4 are hidden in between). You can also click Select All in the top-left corner and then use Unhide to display all at once.
Q4: Will hidden rows/columns appear when printing?
- Solution: No, they will not appear. Hidden rows/columns are not printed by default. Hiding unnecessary content before printing is a common practice.