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

  1. Click the row number you want to hide to select the entire row (hold Cmd to select multiple rows)
  2. Right-click on the selected row numbers
  3. Select the Hide button in the pop-up menu
  4. The selected rows will be hidden, and a double-line indicator will appear between the row numbers

image

Hide Columns

Feature Entry

Select column letters → Right-click menu → Hide button

  1. Click the column letter you want to hide to select the entire column (hold Cmd to select multiple columns)
  2. Right-click on the selected column letters
  3. Select the Hide button in the pop-up menu
  4. The selected columns will be hidden, and a double-line indicator will appear between the column letters

image

Unhide

Feature Entry

Select adjacent rows/columns on both sides of the hidden rows/columns → Right-click menu → Unhide button

  1. 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)
  2. Right-click on the selected row numbers
  3. Select the Unhide button in the pop-up menu
  4. The hidden rows/columns will be restored and displayed

image

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 2 and 5, 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.