ShortcutdrillExcel shortcuts / grouping and structure / Ungroup rows
Ungroup rows in Excel: Alt+Shift+Left arrow (Mac: Cmd+Shift+J)
| Windows | Alt+Shift+Left arrow |
|---|---|
| Mac | Cmd+Shift+J |
| Group | grouping and structure |
Drill: Ungroup. Pro drill. Twenty-five drills are free.
What it does and when to use it
Alt+Shift+Left removes one outline level from the selected rows. Do it before deleting or moving grouped rows, so the outline does not end up pointing at the wrong block.
The common mistake
Ungrouping with only part of the group selected, which splits the group in two.
Related shortcuts
- Insert a column Ctrl+Space, Ctrl+Shift+=
- Delete a blank row Shift+Space, Ctrl+-
- Group rows Alt+Shift+Right arrow
- Collapse the groups Alt, A, H
- Insert a sheet Shift+F11
- The printable cheat sheet
Questions
How do I remove all grouping?
Alt, A, U, C clears the outline for the whole sheet.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill