Insert Row Above Shortcut in Google Sheets

When you’re working in a sheet and realise you need a blank row directly above your current row, the keyboard shortcut beats the menu by a wide margin.

One key combo handles it on both Windows and Mac. It works whether you have a single cell selected or the whole row.

The two cases use slightly different versions of the same shortcut. Below explains which one fires when.

Insert Row Above Keyboard Shortcut in Google Sheets

Insert Row Above Keyboard Shortcut (Windows Windows)

Ctrl + Alt + =

Insert Row Above Keyboard Shortcut (Mac Mac)

⌘ + Option + =

What this shortcut does

With a whole row selected, the shortcut drops a blank row directly above your selection. Existing data shifts down one row to make room.

If you had a single cell selected instead of a whole row, add Shift to the combo (Ctrl + Alt + Shift + = on Windows, ⌘ + Option + Shift + = on Mac). The result is the same.

How to use it (step by step)

  1. Decide which row should sit below the new blank one.
  2. Click that row’s number on the left side of the sheet. The whole row highlights.
  3. Press the shortcut.
  4. A blank row appears above your selection. Old rows shift down.

If you only have a cell selected:

  1. Click any cell in the target row.
  2. Press the Shift variant of the shortcut.
  3. A blank row drops in above the cell’s row.

Alternative method (right-click menu)

Right-click any cell in the target row. Pick “Insert 1 row above”. This is the easiest path when you don’t want to think about the row-vs-cell rule.

The menu also has options for inserting multiple rows at once, which the keyboard shortcut does only by pre-selecting that many rows.

Things to watch for

  • The row’s formatting gets copied. A new row above a bold, coloured row inherits the same look. Clear it from the new row if you want a plain start.
  • Cell selection needs the Shift variant. This trips people up the first few times. Whole row selected: plain shortcut. Single cell selected: add Shift.
  • Mac function-key behaviour. If the combo doesn’t fire, hold Fn with it, or set System Settings → Keyboard → Function Keys to “Use F1, F2 etc. keys as standard function keys”.
  • Multiple rows. Select N rows before pressing the shortcut and Sheets inserts N blank rows.

Google Sheets keyboard shortcuts

Related Google Sheets shortcuts: