Microsoft Office Tutorials and References
In Depth Information
Organizing data into levels
3
Click the row heading of row 5 , and drag to the row heading of row 7 to select rows
5 through 7 .
4
On the Data tab, in the Outline group, click Group to make rows 5 through 7 into a
new group. An outline bar appears on a new level in the outline area, and a
corresponding Level 4 button appears at the top of the outline area.
5
In the outline area, click the Hide Detail button next to row 8 to hide rows 5 through
7 . The Hide Detail button you clicked changes to a Show Detail button.
6
In the outline area, click the Show Detail button next to row 8 to display rows 5
through 7 . In the outline area, click the Level 1 button to hide all rows except row 1
with the column headings and row 28 with the grand total.
7
In the outline area, click the Level 2 button to display the rows that have the
subtotals for each year.
8
In the outline area, click the Level 3 button to display all rows except rows 5
through 7 .
9
In the outline area, click the Level 4 button to display rows 5 through 7 .
CLEAN UP Close the GroupByQuarter workbook, saving your changes if you want to.
Search JabSto ::




Custom Search