Microsoft Office Tutorials and References
In Depth Information
Troubleshooting The appearance of buttons and groups on the ribbon changes depending
on the width of the program window. For information about changing the appearance of
the ribbon to match our screen images, see “Modifying the Display of the Ribbon” at the
beginning of this topic.
When you add subtotals to a worksheet, Excel also defines groups based on the rows
used to calculate a subtotal. The groupings form an outline of your worksheet based
on the criteria you used to create the subtotals. For example, all the rows representing
months in the year 2009 could be in one group, rows representing months in 2010 in
another, and so on. The outline area at the left of your worksheet holds controls you
can use to hide or display groups of rows in your worksheet.