For the group function in Excel, I am able to create groups and levels. However, it seems like if you group a number of rows, and then create a subgroup with the same last element, the "collapse" + button doesn't appear and the last subgroup cannot be collapsed.

Is this a bug with Excel or is there something I can do to fix it? It seems pervasive over several versions, which bugs usually are not, but it seems like it is not a desirable feature.

2

2 Answers

I found that if you uncheck the Summary Rows Below Detail in the Outline/Setting dialog box it moves the plus/minus sign to the top of the grouping and then the last group is included and will expand & collapse properly.

Will83 is Correct, however unchecking "Summary rows below detail" still doesent make it bag-free. This is how: if you group your list from higher levels first and then lower levels after, (meaning if you first group the inside groups and then try to group your inside groups you have made to a group) the problem of the last inside group persists until you group that specific group again. For this reason it will be a good idea to to group the low level first and work your way inward. Hope this makes sense.

Your Answer

Sign up or log in

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

Post as a guest

Post Your Answer Discard

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