Group, Hide and Unhide Rows and Columns in Excel for Mac: Microsoft's Table Disagrees With Itself (2026)
How do you group and ungroup rows and columns in Excel for Mac?
Microsoft and Exceljet both list Cmd+Shift+K to group selected cells and Cmd+Shift+J to ungroup them, while Microsoft lists Ctrl+8 to display or hide the outline symbols.
Select the rows or columns, press Cmd+Shift+K, and press Cmd+Shift+J to ungroup. Exceljet says the group shortcut groups selected rows or selected columns. We did not open a source for what happens when both rows and columns are selected.
How do you hide and unhide rows and columns?
Microsoft's Outline data table lists Ctrl+9 to hide rows, Ctrl+Shift+( to unhide rows, Ctrl+0 to hide columns and Ctrl+Shift+) to unhide columns, and Exceljet lists the same keys.
Microsoft's Windows section also lists Ctrl+9 for hiding the selected rows and Ctrl+0 for the selected columns, so these keys match the Windows habit. Exceljet writes the unhide shortcuts as Control+Shift+9 and Control+Shift+0, which are the same keys as the parenthesis versions.
Why does Microsoft's own table contradict itself?
A second Microsoft table lists Ctrl+( to hide a row and Ctrl+) to hide a column, but on a US keyboard those are the same keystrokes the outline table assigns to unhiding.
The second table, under format and edit data, lists Hide a row as Cmd+( or Ctrl+( and Hide a column as Cmd+) or Ctrl+). A parenthesis needs Shift on a US keyboard, so Ctrl+( is the same physical keystroke as Ctrl+Shift+9, which the outline table lists as Unhide selected rows. We read the outline set as the likelier correct one because Exceljet and Microsoft's Windows rows agree with it, but we have not tested it on a Mac. If the keys do nothing, use the Format menu or the right-click menu instead; we did not source the menu path.
What do the sources say?
The outline set of Microsoft and Exceljet agrees on Ctrl+9, Ctrl+0 and their Shift versions, while Microsoft's format table lists Cmd or Ctrl with parentheses for hiding, which clashes with the unhide keys.
| Task | Microsoft: Outline data | Microsoft: Format and edit data | Exceljet |
|---|---|---|---|
| Group selected cells | Cmd+Shift+K | Not listed | Cmd+Shift+K |
| Ungroup selected cells | Cmd+Shift+J | Not listed | Cmd+Shift+J (index) |
| Show or hide outline symbols | Ctrl+8 | Not listed | Not opened |
| Hide rows | Ctrl+9 | Cmd+( or Ctrl+( | Control+9 |
| Unhide rows | Ctrl+Shift+( | Shift+Cmd+( or Ctrl+Shift+( | Control+Shift+9 (index) |
| Hide columns | Ctrl+0 | Cmd+) or Ctrl+) | Control+0 (index) |
| Unhide columns | Ctrl+Shift+) | Shift+Cmd+) or Ctrl+Shift+) | Control+Shift+0 (index) |
Where does Mac Excel Shortcuts fit?
Mac Excel Shortcuts is our app that replicates Windows Excel shortcuts on a Mac. We did not check whether it covers these keys, so see the covered-list page before relying on it.
It has a free trial of 7 days or 10 shortcut uses, then costs $49 once or $4.99 a month. This page is not a test of the app. See the list of shortcuts it covers.
FAQs
What is the shortcut to hide a row in Excel for Mac?
Microsoft and Exceljet list Ctrl+9. A second Microsoft table lists Cmd+( or Ctrl+( for the same task, so verify on your Mac.
How do I unhide rows on a Mac?
Microsoft and Exceljet list Ctrl+Shift+9, written Ctrl+Shift+( by Microsoft. Select the rows around the hidden ones first.
How do I group rows in Excel for Mac?
Microsoft and Exceljet list Cmd+Shift+K to group and Cmd+Shift+J to ungroup.
Which table should I trust?
We trust the outline set because two sources agree and it matches Windows. We did not test it on a Mac.
Related guides
Mac Excel shortcut cheat sheet: the wider list.
Why Excel keyboard shortcuts do not work on Mac: the conflict checklist.
Excel for Mac vs Windows differences: what else differs.
How we checked this guide
We opened the pages below on November 15, 2026. We read Microsoft's Excel for Mac shortcut table directly from the page and compared it with the other sources. We did not test Excel on a Mac. Limits: Microsoft carries no edit date and lists two conflicting sets; the Exceljet unhide and ungroup rows come from its index page only; our reading that Ctrl+( equals Ctrl+Shift+9 assumes a US keyboard layout.
References
Microsoft Support, Keyboard shortcuts in Excel, undated (page footer shows 2026). Mac section read November 15, 2026.
Exceljet, Excel shortcuts, undated. Accessed November 15, 2026.
