⚑Rows & Columns

How to ungroup rows or columns in Google Sheets

Ungroup previously grouped rows or columns.

Alt + Shift + Left Arrow

πŸ“‹ Step-by-Step Guide

  1. 1.Open Google Sheets in your browser.
  2. 2.Select the cell(s) you want to work with.
  3. 3.Press Alt + Shift + Left Arrow to ungroup rows or columns.

🎯 Shortcut Keys by Platform

PlatformShortcut
πŸ’» PC / Windows
Alt + Shift + Left Arrow
🍎 Mac
Option + Shift + Left Arrow
πŸ’» Chrome OS
Alt + Shift + Left Arrow

πŸ’‘ Pro Tips

  • You can combine this shortcut with the other Common Actions shortcuts to speed up your workflow.
  • If you forget this shortcut, press Ctrl + / (or ⌘ + / on Mac) to see all available keyboard shortcuts in Google Sheets.

❓Frequently Asked Questions

πŸ“š

Explore All Google Sheets Shortcuts

Discover all 111 keyboard shortcuts to speed up your workflow and boost your productivity.

View All Shortcuts ➜