Learn How To Use Group And Outline Buttons To Collapse Subtotaled Data With This Microsoft Excel Tutorial

See all Microsoft Excel tips


Strategy: Look to the left of column A, above cell A1. A series of three small numbers appear, as shown in Fig. 671. These are the Group & Outline buttons.

Using the mouse, choose the small 2 button. You will see just the customer totals, as shown in Fig. 672.

As shown in Fig. 673, choose the small 1 button to see just the grand total (which seems a bit pointless).

Choose the 3 button to go back to the detail view, with all records, as shown in Fig. 674.

Additional Details: In the 2 button view, you can explode a single customer’s detail records by clicking the + next to the customer total, as shown in Fig. 675.

Use the minus sign next to A32, as shown in Fig. 675, to collapse the detail again. Or, select the 2 button to collapse all.

Summary: After using the Subtotals command, the Group & Outline buttons allow you to create multiple views of the data.

Commands Discussed: Data – Subtotals; Group & Outline


See all Microsoft Excel tips




Fig. 671
Fig. 672
Fig. 673
Fig. 674
Fig. 675