I cannot figure out how to have one cell grouped to contain other cells that are expandable/collapsible.
What I am trying to do is have cell A1 contain "Stats" while cell A2, A3, A4, A5 be collapsible/expandable within cell A1.
Is this possible to do in Google Sheets?
So far the only thing that I can figure out, is to "hide" rows. Kind of a pain in the butt compared to Excel, however it guess it will work unless someone has a method that functions like Excel's.
Right-click any of the plus or minus signs for a group. Then, select “Expand All Row/Column Groups” or “Collapse All Row/Column Groups.” This lets you expand or collapse all of your row or column groups in one fell swoop.
To hide multiple rows in a Google Spreadsheet, click on the first row and drag across the rows you wish to hide, or hold the Shift key and click on the last row you want to hide. Then right click and select Hide rows X - X, where X indicates the numbers of the rows you have selected.
This function was added to G Suite as of May 2018. Select a group of rows, right-click on them, and select "Group Rows ##-##".
Google Documentation
The interface is a bit clunky, but it does work!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With