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?
11 Answer
No, this is not possible. In Excel only whole rows or whole columns can be hidden or collapsed.