Excel: Use Group & Outline Buttons to Collapse Subtotaled Data

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: I just used the Subtotal command in "œAdd Subtotals to a Data Set," and now I want to print the total rows in order to create a summary report for my manager.

Strategy: If you look above and to the left of cell A1, you'll see a series of three small numbers. These are the Group & Outline buttons. You can use them to collapse subtotaled data. If you click the small 2 button, you will see just the customer totals.

  1. One row per customer.

    Click the small 1 button to see only the grand totals.

    Click the 3 button to go back to all detail rows.

    Additional Details: In the 2 button view, you can collapse or expand a single customer's detail records by clicking the - or + symbols next to the customer total.