📊 Category

Rows & Columns Shortcuts for Google Sheets

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

Alt + I, then R
Insert Row AboveInsert a new row above the currently selected row.
Alt + I, then B
Insert Row BelowInsert a new row below the currently selected row.
Alt + I, then L
Insert Column LeftInsert a new column to the left of the currently selected column.
Alt + I, then R
Insert Column RightInsert a new column to the right of the currently selected column.
Alt + E, then D
Delete RowDelete the currently selected row and shift remaining rows up.
Alt + E, then E
Delete ColumnDelete the currently selected column and shift remaining columns left.
Ctrl + Alt + 9
Hide RowHide the currently selected row(s) from view without deleting them.
Ctrl + Alt + 0
Hide ColumnHide the currently selected column(s) from view without deleting them.
Ctrl + Shift + 9
Unhide RowReveal previously hidden rows in your spreadsheet.
Ctrl + Shift + 0
Unhide ColumnReveal previously hidden columns in your spreadsheet.
Alt + Shift + Right Arrow
Group Rows or ColumnsGroup the selected rows or columns together for collapsible sections.
Alt + Shift + Left Arrow
Ungroup Rows or ColumnsUngroup previously grouped rows or columns.
Alt + Shift + Down Arrow
Expand Grouped Rows or ColumnsExpand collapsed grouped rows or columns to show their contents.
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 across 8 categories

View All Shortcuts ➜

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