Collapse Outline to Show Just Subtotals in Excel & Google Sheets

In this article, you will learn how to collapse outline to show just subtotals in Excel and Google Sheets.

Collapse Outline to Show Just Subtotals

Let’s say that we have the following data set with subtotals for every product in column D.

When we have data group by a column and subtotals displayed, we can collapse details level, and display only subtotals. In order to achieve this, we need to click on the outline bar number that we want to collapse (in our case, outline level 2).

As a result, only subtotals for products are displayed, will detail lines are collapsed.

In the outline bar, number 1 is always referring to the Grand Total, while subtotals get numbers starting from 2, as they are added. Let’s suppose that we have two levels of subtotals, and add a subtotal for months (column C).

As you can see, now we have one more outline level (3) for month subtotals. To collapse these subtotals, we need to click on number 3 in the outline bar.

As a result, detail rows are collapsed, and only subtotals are displayed. This time, both month and product subtotals are displayed.

Collapse Outline to Show Just Subtotals in Google Sheets

Let’s see how rows grouped by product look like in Google Sheets.

In order to collapse detail rows and display only subtotals per product, click on the minus sign in the outline bar.

Now we have to repeat this step for every product group. In the end, only subtotal rows are displayed.