Insert Row Below Shortcut in Google Sheets

When you’re adding data to a sheet, the new row often needs to land right below the one you’re working on. Reaching for the menu every time is slow.

Google Sheets does not have a separate keystroke for “insert row below”. But the standard insert-row shortcut, paired with a small selection trick, gets you there in under a second.

The same combo works on Windows and Mac.

Insert Row Below Keyboard Shortcut in Google Sheets

Insert Row Below Keyboard Shortcut (Windows Windows)

Ctrl + Alt + =

Insert Row Below Keyboard Shortcut (Mac Mac)

⌘ + Option + =

What this shortcut does

With a whole row selected, the shortcut inserts a blank row directly above your selection.

There is no separate keystroke for inserting below. The trick is to select the row that sits just BELOW where the new row should land. The insert-above behaviour then drops the row exactly where you want it.

How to use it (step by step)

  1. Find the row you want the new row to appear under.
  2. Click the row number of the row immediately below it (the whole row highlights).
  3. Press the shortcut.
  4. A blank row drops in above your selection, which is right below your original target.
  5. If you had a single cell selected instead of a whole row, use Ctrl + Alt + Shift + = on Windows or ⌘ + Option + Shift + = on Mac.

Alternative method (right-click menu)

Right-click any cell in the row you want the new row to appear under. Pick “Insert 1 row below” from the menu.

This is the most direct path when you have a single cell selected and don’t want to think about the row-vs-cell selection rule.

Things to watch for

  • Row vs cell selection matters. Whole-row selection uses the plain combo, single-cell selection uses the Shift variant. Sheets is strict about this.
  • One row at a time, unless you select more. To insert several blank rows at once, select that many rows first. The shortcut inserts the same number it sees selected.
  • Mac function-key behaviour. If ⌘ + Option + = does nothing, hold Fn with the combo, or set function keys to standard in System Settings.
  • The new row inherits formatting from the row above it. If the row above is bold or has a fill color, the new row picks that up.

Google Sheets keyboard shortcuts

Related Google Sheets shortcuts: