Group and Ungroup Rows in Excel 2011 for Mac

By Geetesh Bajaj, James Gordon

In Office 2011 for Mac, use Excel’s Group tool to identify ranges of rows in worksheets that you can then turn on and off. Activate the rows by using switches in a new margin that’s displayed when Group is active. Group is particularly useful when you have large tables with Total Rows turned on because it lets you hide data rows to reduce visual clutter on a busy worksheet.

To group an Excel worksheet that has multiple data tables that all begin flush left (or at least in the first few columns), do the following:

  1. Select the rows that contain the tables with Total Rows turned on.

    Tables need at least one empty row between them as separators. Contracted rows may not be included in Total Row calculations.

  2. On the Ribbon’s Data tab, go to the Group & Outline group and choose Group→Auto Outline.

    Excel turns on the group controls in a new margin.

To use the new controls, here’s what you do:

  • Click the 1 button at the top of the new margin to contract all groups. A plus sign displays next to the Total Row of each contracted group.

  • Click the + and – signs in the margin to expand or contract individual tables.

  • Click the 2 button at the top of the new margin to expand all groups.


You can select a range of adjacent rows within a single table and on the Ribbon’s Data tab; go to the Group & Outline group and choose Group→Group to group just the selected rows.

To ungroup, go to the same Group & Outline group on the Data tab and choose Ungroup→Ungroup or Clear Outline.