Ungroup rows columns: the shortcut in both apps
On Windows it is usually Alt+Shift+← (2 of 2 apps). The table shows where each app agrees and where it differs.
| App | Mac | Windows | Linux |
|---|---|---|---|
| Google SheetsUngroup rows or columns | OptionShift← | AltShift← | AltShift← |
| ExcelUngroup the selected rows or columns | ShiftCmdJ | AltShift← | — |
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.