Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Collapsing Google spreadsheet cells into a single cell

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.

like image 513
Jordan Avatar asked Jan 09 '14 23:01

Jordan


People also ask

How do you make collapsible cells in Google Sheets?

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.

How do I collapse multiple rows in Google Sheets?

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.


1 Answers

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!

like image 195
EvangeliusAg Avatar answered Oct 02 '22 13:10

EvangeliusAg