Skip to content

hiderows

Hide rows.

hiderows(cr1, cr2, ...)

Hides the rows containing the given cell ranges from view. The rows still exist (formulas referencing them keep working); they’re just not displayed. Restore visibility with unhiderows.

hiderows(A5:A10)
  • unhiderows — Show previously hidden rows.
  • hidecols — Hide columns.
  • grouprows — Group rows so they can be collapsed / expanded as a unit.