How to group and outline rows in Excel on Mac: steps for Microsoft 365 users

What row grouping does in an Excel sheet

Grouping rows stacks detail rows under one summary row. You collapse the detail to see only the total, then expand it when a figure needs checking. Excel draws the outline in the left margin, with a bracket line beside the rows and a button to collapse or expand them.

Grouping suits sheets with a clear hierarchy. A daily sales log with a total row under each month is a good example. So is a budget with detail lines under each category heading. Collapse the sheet to read the category totals, then open one category when a number looks wrong.

Grouping changes only how rows look. Microsoft's outline guide describes a Clear Outline command that removes the outline without deleting data. That makes grouping easy to undo, so test it on a copy first if the sheet matters.

Structure also helps you check your work. A 2008 paper by Panko reviewed fifteen years of research and found spreadsheet errors to be common and non-trivial. Collapsing a sheet to check totals against their detail is one simple habit that helps you catch mistakes.

Unhide rows before you group them on Mac

Hidden rows and filtered rows can throw off a manual group. Microsoft's outline guide says to display all data before grouping by hand, because hidden data can lead to incorrect grouping. Clear any filter on the sheet first.

To unhide everything, click the blank box where the row and column headers meet. Then go to Home > Cells > Format > Hide & Unhide and pick the option for unhiding rows. Group the rows only after every row you expect is visible.

Group rows with the Data tab on Mac

Microsoft's outline guide gives the path Data > Outline > Group > Group. The Data tab sits after Formulas in the ribbon, and its Outline group holds the grouping tools.

Group is the first item, and its arrow opens Auto Outline. Ungroup has its own menu with Ungroup and Clear Outline. Ungroup works on the rows you select, while Clear Outline removes the outline itself.

Microsoft's outline guide is not a Mac-specific page, so labels may differ slightly in your build. If they do, look in the Outline group on the Data tab for the Group button.

Mac shortcuts for grouping and outlining rows

Microsoft says many Windows Ctrl shortcuts also work with Control in Excel for Mac. Grouping and ungrouping use Command and Shift instead, so ⌘⇧K and ⌘⇧J are the pair to remember.

Use the shortcut and select whole rows first

Exceljet advises selecting whole rows or columns before you group. If you select only cells, Excel asks whether to group rows or columns. Whole rows skip that question and group straight away.

Click the row number at the left edge of the first row. Hold Shift and click the last row number in the group. Press ⌘⇧K, and the outline bar appears in the margin.

The keys have been around for a while. A 2012 Microsoft Q&A answer about Excel 2011 lists the same Command and Shift pair for grouping and ungrouping. That answer came from a community member, not Microsoft staff, so check the keys on your own build.

Auto Outline for sheets with total rows

Auto Outline builds groups for you when the sheet has summary formulas. Microsoft's guide places it at Data > Outline > Group arrow > Auto Outline. Excel looks for summary rows whose formulas point at the detail rows near them.

Auto Outline works best when totals sit in predictable places. A row that sums the rows above it gives Excel a clear detail range. If totals are scattered or mixed with notes, the outline can group the wrong rows, so check the result before you save.

If Auto Outline gets it wrong, choose Data > Outline > Ungroup > Clear Outline. Then group the rows by hand. Clear Outline keeps your data, so only the groups go away.

Collapse, expand, and move the summary row

Each group has a summary row. Microsoft's guide says the summary sits below the detail by default. Excel can place it above the detail instead, which suits reports where each block starts with its heading.

To move the summary, open the Outline group's dialog launcher and clear Summary rows below detail. For column groups, clear Summary columns to right of detail instead.

Press ⌃8 to show or hide the outline symbols. Use it when the margin buttons vanish and you need them back. Microsoft lists ⌃8 as the Mac shortcut for displaying or hiding outline symbols.

Excel for the web follows the same Data > Outline path. It cannot set the summary position or apply outline styles, so make those changes in the desktop app on your Mac.

Group columns the same way

The same steps group columns. Select whole column letters, then choose Data > Outline > Group > Group and pick Columns. Exceljet's shortcut page lists ⌘⇧K for rows or columns, so the same keys apply.

Ungroup rows or clear the outline on Mac

Select the grouped rows, then choose Data > Outline > Ungroup > Ungroup. You can also press ⌘⇧J. The rows return to a flat list, and the margin bar disappears.

To remove the whole outline from a sheet, choose Data > Outline > Ungroup > Clear Outline. Microsoft says this removes the outline without deleting data. Your rows stay where they were, just without the collapse buttons.

Why the Group button is greyed out

A greyed-out Group button has a cause, and it is often one of the following. Microsoft's outline guide does not list these causes. They come from user reports on forums and help sites, so treat each one as a lead to check.

• Protected sheet. The sheet blocks outline changes. Unprotect it if you know the password, or ask the person who protected it.
• Several sheets selected. Excel may disable some commands while sheets are selected together. Click one sheet tab to clear the selection.
• Active cell inside a Table. Click a cell outside the Table, then try again. Test this on a copy first.
• Hidden or filtered rows. Clear the filter, unhide the rows as described above, then group again.

If none of these fit, check that the workbook is not read-only. A read-only copy cannot save outline changes.

Mistakes people make with row groups

• Putting the summary row inside its own group. Collapsing the group then hides the total as well, which defeats the point.
• Grouping to hide errors. Collapsed rows hide detail, not mistakes. Expand every group and check the numbers before you share the file.
• Expecting grouping to sort rows. Grouping does not reorder anything. Sort first, then group.
• Leaving the outline symbols off. If you hide them with ⌃8 and forget, the sheet looks ungrouped to everyone who opens it.

Check a grouped sheet before you share it

Expand every group before you send a file. Scan each summary row against the detail under it. Save one copy with the groups collapsed for a clean summary, and one with them open for the people who need the detail.

Which Excel build to check first

Microsoft's Excel for Mac release notes list build 16.114.3 (Build 26102720) as the newest entry at the time of writing. It is dated October 27, 2026.

The October builds from 16.113.4 through 16.114.3 list quality, performance and security fixes only, with no changes to the Data tab or outlines. Check your own build under Excel > About Excel, and trust your screen over this guide if the labels differ.

What to do next with grouped rows

Save a copy of any workbook before you group a sheet others rely on. Group the copy, collapse and expand it, and check the totals. Then repeat the steps on the original.

If you need totals by category rather than collapsible detail, a pivot table may suit the job better. The steps are in how to make a pivot table in Excel on Mac.

Clean the data before you total it. Text that looks like numbers gets skipped by sums. The fixes are in how to convert text to numbers in Excel on Mac.