Home·Keyboard shortcuts

Google Sheets · Insert a row below

Rows

Windows · Linux

Alt+I·R·B

Mac

Ctrl+Option+I·R·B

Adds one row below; this is a menu walk pressed in order rather than one combination, and in browsers other than Chrome the first step becomes Alt+Shift+I.

Group
Rows
Keys held
2

It runs inside the browser, so combinations the browser claims first — Ctrl+W, for one — never reach the sheet. That is why so many Sheets shortcuts use Alt/Option.

Reading the key names

  • Keys joined by + are pressed together: Ctrl+Shift+P means hold Ctrl and Shift, then P.
  • On a Mac, Cmd is ⌘, Option is ⌥ (labelled Alt on some keyboards), Control is ⌃ and Shift is ⇧.
  • Windows Ctrl usually becomes Cmd on a Mac, but not always — this reference lists both combinations separately.
  • With a Korean, Japanese or Chinese input method active, shortcuts built on letter keys may not fire. Switch to Latin input and try again.
  • When a combination does nothing, another program has often claimed it as a global shortcut first.

Common questions

Q. What is the shortcut for Insert a row below in Google Sheets?

Adds one row below; this is a menu walk pressed in order rather than one combination, and in browsers other than Chrome the first step becomes Alt+Shift+I. It is Alt+I R B on Windows and Ctrl+Option+I R B on a Mac.

Q. Is it the same on Windows and Mac?

No — Alt+I R B on Windows, Ctrl+Option+I R B on a Mac.

Q. How many keys is that?

2 pressed together. The combination sits under Rows in Google Sheets.

Shortcuts nearby