Group rows or columns in Google Sheets
In Google Sheets, press Option+Shift+→ (Mac), Alt+Shift+→ (Windows, Linux).
EscF1F2F3F4F5F6F7F8F9F10F11F12PrtScScrLkPause
`1234567890-=deleteInsHomePgUp
TabQWERTYUIOP[]\DelEndPgDn
CapsASDFGHJKL;'return
ShiftZXCVBNM,./Shift↑
fnctrloptcmdcmdopt←↓→
EscF1F2F3F4F5F6F7F8F9F10F11F12PrtScScrLkPause
`1234567890-=BkspInsHomePgUp
TabQWERTYUIOP[]\DelEndPgDn
CapsASDFGHJKL;'Enter
ShiftZXCVBNM,./Shift↑
CtrlWinAltAltWinMenuCtrl←↓→
EscF1F2F3F4F5F6F7F8F9F10F11F12PrtScScrLkPause
`1234567890-=BkspInsHomePgUp
TabQWERTYUIOP[]\DelEndPgDn
CapsASDFGHJKL;'Enter
ShiftZXCVBNM,./Shift↑
CtrlSuperAltAltSuperMenuCtrl←↓→
See it happen Press the shortcut above, or
More Google Sheets shortcuts: rows and columns
| Action | Mac | Windows | Linux |
|---|---|---|---|
| Insert rows or columns | OptionCmd= | CtrlAlt= | CtrlAlt= |
| Delete rows or columns | OptionCmd- | CtrlAlt- | CtrlAlt- |
| Hide rows | OptionCmd9 | CtrlAlt9 | CtrlAlt9 |
| Unhide rows | ShiftCmd9 | CtrlShift9 | CtrlShift9 |
| Hide columns | OptionCmd0 | CtrlAlt0 | CtrlAlt0 |
| Unhide columns | ShiftCmd0 | CtrlShift0 | CtrlShift0 |
| Ungroup rows or columns | OptionShift← | AltShift← | AltShift← |