I found some related links which can help you on this. As Excel will override your Groups and substitute with its own Groups.

Right now if I choose Auto Outline it ungroups previous selected groups of rows.Ī: This is normal behavior of Excel.

Auto Outline on the other hand is something where excel itself identifies Subtotal rows and create Groups.

useĪ: Not required for Group, it’s required when you choose Auto Outline.Ī: Group if you want to do the selection of rows manually. In such a case, you can group rows manually i.e. If your worksheet contains two or more levels of information, Excel's Auto Outline may not group your data correctly. If your dataset contains just one level of information, the fastest way would be to let Excel group rows for you automatically i.e. Grouping in Excel works best for structured worksheets that have column headings, no blank rows or columns, and a summary row (subtotal) for each subset of rows. It’s been a while since you posted this thread, I would like to help on this. When I do use outline/groups, it seems the filter function does not list the fields that are part of these groups even when they are expanded. Should I do this step in the beginning or once all the smaller groups are created? Once I am finished grouping all of these small sets of rows, then I'd like to group a much larger set which will include hundreds of these smaller sets. If I select a set of rows and choose group, then choose an adjacent set of rows to and select group, it bunches the two sets that I want in separate groups together.įor instance, Row 5604 through 5608 are grouped and I see the plus/minus sign out to the left for just those rows, but then when I select rows 5609 through 5614 and choose group, all of a sudden the plus/minus sign now includes rows 5604 through 5614.

Right now if I choose Auto Outline it ungroups previous selected groups of rows If I select a set of rows, do I choose Group or Auto Outline? If I select a set of rows that I want to group, must I have a subtotal row at the bottom of the group of rows? This is the first time I am working with the Outline/Groups function and by following all the non-Mac information out there I am still having difficulty.

Excel for mac 2011 nested if