Ungroup Rows or Columns
Windows
Alt+Shift+←
Ungroups the selected rows or columns.
Excel Ungroup Rows or Columns Shortcut for Windows, Mac & Web
Ungroups the selected rows or columns. Here's the keyboard shortcut for every version of Excel, plus other ways to do it.
Quick Answer
- Windows
- Alt+Shift+←
- Mac
- Cmd+Shift+J
- Web
- Not confirmed yet
How to ungroup rows or columns in Excel with the keyboard
- Open Excel and go to where you want to ungroup rows or columns.
- Press Alt + Shift + ← on Windows or Cmd + Shift + J on Mac.
Excel Ungroup Rows or Columns Shortcut for Windows
Press Alt + Shift + ←.
Excel Ungroup Rows or Columns Shortcut for Mac
Press Cmd + Shift + J.
Excel Ungroup Rows or Columns Shortcut for Excel Web
We haven't confirmed a Excel Web shortcut for this yet.
Related Shortcuts
Frequently asked questions
What is the Excel ungroup rows or columns shortcut?
On Windows, press Alt + Shift + ←. On a Mac, press Cmd + Shift + J.
Is there a Mac shortcut to ungroup rows or columns in Excel?
Yes: Cmd + Shift + J.
Does it work in Excel for the web?
We haven't confirmed a web version shortcut for this yet.
Not yet verified · Last reviewed: not yet reviewed · Microsoft's official shortcut list