Excel Collapsable Rows

%3CLINGO-SUB%20id%3D%22lingo-sub-1608968%22%20slang%3D%22en-US%22%3EExcel%20Collapsable%20Rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1608968%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20how%20to%20create%20collapsible%20rows%20in%20excel%20by%20using%20the%20group%20data%20tool%2C%20but%20I%20don't%20like%20how%20it%20places%20the%20(%2B)%20and%20(-)%20down%20a%20row%20and%20all%20the%20way%20to%20the%20left.%20Is%20it%20possible%20to%20locate%20these%20toggles%20in%20the%20same%20cell%20as%20the%20header%20of%20the%20data%20you%20are%20collapsing.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I know how to create collapsible rows in excel by using the group data tool, but I don't like how it places the (+) and (-) down a row and all the way to the left. Is it possible to locate these toggles in the same cell as the header of the data you are collapsing.

1 Reply
Highlighted

@christbaumga 

No, Excel doesn't provide for this. You might post a request at Excel UserVoice