πŸ“Š Category

Rows & Columns Shortcuts for Google Sheets

Insert, delete, hide and manage rows and columns. Browse all 14 shortcuts below.

Alt + I, then R
Windows / PC
Windows: Alt + I, then R. Mac: Ctrl + Option + I, then R.Chrome OS: Alt + I, then R.Insert Row AboveInsert a new row above the currently selected row.
Alt + I, then B
Windows / PC
Windows: Alt + I, then B. Mac: Ctrl + Option + I, then B.Chrome OS: Alt + I, then B.Insert Row BelowInsert a new row below the currently selected row.
Alt + I, then L
Windows / PC
Windows: Alt + I, then L. Mac: Ctrl + Option + I, then L.Chrome OS: Alt + I, then L.Insert Column LeftInsert a new column to the left of the currently selected column.
Alt + I, then R
Windows / PC
Windows: Alt + I, then R. Mac: Ctrl + Option + I, then R.Chrome OS: Alt + I, then R.Insert Column RightInsert a new column to the right of the currently selected column.
Alt + E, then D
Windows / PC
Windows: Alt + E, then D. Mac: Ctrl + Option + E, then D.Chrome OS: Alt + E, then D.Delete RowDelete the currently selected row and shift remaining rows up.
Alt + E, then E
Windows / PC
Windows: Alt + E, then E. Mac: Ctrl + Option + E, then E.Chrome OS: Alt + E, then E.Delete ColumnDelete the currently selected column and shift remaining columns left.
Ctrl + Alt + 9
Windows / PC
Windows: Ctrl + Alt + 9. Mac: ⌘ + Option + 9.Chrome OS: Ctrl + Alt + 9.Hide RowHide the currently selected row(s) from view without deleting them.
Ctrl + Alt + 0
Windows / PC
Windows: Ctrl + Alt + 0. Mac: ⌘ + Option + 0.Chrome OS: Ctrl + Alt + 0.Hide ColumnHide the currently selected column(s) from view without deleting them.
Ctrl + Shift + 9
Windows / PC
Windows: Ctrl + Shift + 9. Mac: ⌘ + Shift + 9.Chrome OS: Ctrl + Shift + 9.Unhide RowReveal previously hidden rows in your spreadsheet.
Ctrl + Shift + 0
Windows / PC
Windows: Ctrl + Shift + 0. Mac: ⌘ + Shift + 0.Chrome OS: Ctrl + Shift + 0.Unhide ColumnReveal previously hidden columns in your spreadsheet.
Alt + Shift + Right Arrow
Windows / PC
Windows: Alt + Shift + Right Arrow. Mac: Option + Shift + Right Arrow.Chrome OS: Alt + Shift + Right Arrow.Group Rows or ColumnsGroup the selected rows or columns together for collapsible sections.
Alt + Shift + Left Arrow
Windows / PC
Windows: Alt + Shift + Left Arrow. Mac: Option + Shift + Left Arrow.Chrome OS: Alt + Shift + Left Arrow.Ungroup Rows or ColumnsUngroup previously grouped rows or columns.
Alt + Shift + Down Arrow
Windows / PC
Windows: Alt + Shift + Down Arrow. Mac: Option + Shift + Down Arrow.Chrome OS: Alt + Shift + Down Arrow.Expand Grouped Rows or ColumnsExpand collapsed grouped rows or columns to show their contents.
Alt + Shift + Up Arrow
Windows / PC
Windows: Alt + Shift + Up Arrow. Mac: Option + Shift + Up Arrow.Chrome OS: Alt + Shift + Up Arrow.Collapse Grouped Rows or ColumnsCollapse grouped rows or columns to hide their contents.
πŸ“š

Explore All Google Sheets Shortcuts

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

View All Shortcuts ➜

⚑ Accelerator Keys

Accelerator Keys shows you browser shortcuts the moment you need them - no cheat sheets, no memorizing.

Add to browser - it's free

Browse Other Categories

⚑

Common Actions

Essential everyday shortcuts for Google Sheets productivity.

25 shortcuts

🎨

Formatting

Format cells, text, and numbers quickly with keyboard shortcuts.

24 shortcuts

🧭

Navigation

Navigate spreadsheets efficiently with keyboard shortcuts.

17 shortcuts

πŸ”’

Formulas

Work with formulas and functions using keyboard shortcuts.

6 shortcuts

πŸ’¬

Notes & Comments

Add notes, comments, and collaborate with your team.

6 shortcuts

πŸ“‹

Menus

Open and navigate menus using keyboard shortcuts.

13 shortcuts

β™Ώ

Accessibility & Screen Readers

Accessibility shortcuts for screen readers and braille support.

6 shortcuts