Group rows and columns (like in Excel) by typing "<hide>" in the desired first row or column of a Google Sheet.
Hide and un-hide multiple groups of rows and columns!
Simplify creation of spreadsheets for different audiences by hiding and un-hiding detail.
How to use:
- Type "<hide>" in the first column of the desired row(s) to group.
- Type "<hide>" in the first row of the desired column(s) to group.
- Go to the menu: Add-ons -> Group Rows & Columns -> Group Rows (or Group Columns)
For more advanced groupings use the "Group Layer2 Rows" and type "<hide>" in the second column.