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

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 | + data1 |
|---------|----------|
| hello | + data2 |
|---------|----------|
| | |
|---------|----------|
| | |

And opening data 1 would turn into:

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

Is this possible to do in Excel?

1

1 Answer

No, this is not possible. In Excel only whole rows or whole columns can be hidden or collapsed.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

You Might Also Like