Excel 2013: Is it possible to collapse rows only in a specific column?

Posted by h7u9i on Super User See other posts from Super User or by h7u9i
Published on 2014-05-28T03:17:29Z Indexed on 2014/05/28 3:33 UTC
Read the original article Hit count: 437

In my spreadsheet, I'm trying to figure out a way to collapse rows in a specific column.

Right now, if I do Data -> Group -> Group... -> Rows, it'll collapse the entire row. I want to collapse rows only in a specific column.

Example:

|---------|----------|
|  hi     |  + data  |
|---------|----------|
|  hello  |  + data2 |
|---------|----------|
|         |          |
|---------|----------|
|         |          |

And opening data 1 would turn into:

|---------|----------|
|  hi     | - data1  |
|---------|----------|
|  hello  | point1   |
|---------|----------|
|         | point2   |
|---------|----------|
|         | + data2  |
|---------|----------|
|         |          |
|---------|----------|
|         |          |

Is this possible to do in Excel?

© Super User or respective owner

Related posts about microsoft-excel

Related posts about microsoft-excel-2013