Excel Use Group & Outline Buttons to Collapse Subtotaled Data
This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Use Group & Outline Buttons to Collapse Subtotaled Data
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.
Figure 648 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.