graphic1

Exam 77-420 Microsoft Excel 2013
2. Create Cells and Ranges
2.3 Order and Group Cells and Ranges: Create Outlines (Collapse Groups of Data in Outlines)

graphic2

Data -> Outline-> Subtotal

Viewing the Subtotals

The information is outlined on the left hand side of the spreadsheet.

 

You can use the outline to show or hide the details. The + sign means there is more to see. The – sign indicates that all of the Rows are shown.

 

4. Try It: Use the Outline

Go to the Outline at the top of the left side.
Click on the 3. All Rows are visible.

Click on the 2: That's the Subtotals.

Click on the 1. That hides all of the Rows except the Grand Count.

 

Made You Look: In this image, you are looking at Column E, so that it will fit on the page, OK?