⚑Rows & Columns

How to collapse grouped rows or columns in Google Sheets

Collapse grouped rows or columns to hide their contents.

Alt + Shift + Up 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 + Up Arrow to collapse grouped rows or columns.

🎯 Shortcut Keys by Platform

PlatformShortcut
πŸ’» PC / Windows
Alt + Shift + Up Arrow
🍎 Mac
Option + Shift + Up Arrow
πŸ’» Chrome OS
Alt + Shift + Up 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 111 keyboard shortcuts to boost your productivity

View All Shortcuts ➜