Skip to content

↑↓ moveEnter openEsc close

Ungroup rows columns: the shortcut in both apps

2 apps · Mac, Windows and Linux

On Windows it is usually Alt+Shift+← (2 of 2 apps). The table shows where each app agrees and where it differs.

AppMacWindowsLinux
Google SheetsUngroup rows or columnsOptionShift←AltShift←AltShift←
ExcelUngroup the selected rows or columnsShiftCmdJAltShift←—

Small screen: your system's keys only. Open an app's row for every system.

A dash means the app has no default binding, or does not run, on that system. Open a row for notes and the full key details.

How the apps compare

  • Mac: Option+Shift+← in Google Sheets; Cmd+Shift+J in Excel.
  • Windows: every app here uses AltShift←.
  • Linux: Alt+Shift+← in Google Sheets.

Learn it by pressing it: Google Sheets shortcuts practice or Excel shortcuts practice.