Google-sheets – Shortcut to insert new row in Google Spreadsheets

google sheetskeyboard shortcuts

Is there a way to do this without using the menu?

I have seen references to ctrl + space and ctrl + +, but this no longer works (zooms in and out in Google Chrome)

Best Answer

While it's not directly possible in the current version with its own keystroke, there is another very simple way to accomplish this.

First, be located in the row on which you want to insert a row above or below.

Then do the following (keys are on Mac, so translate as necessary for your OS):

  1. Ctrl + Option + I - invokes the Insert menu
  2. Then hit the R key for Row Above, or the B key for Row Below

I guess this way may actually be one less keystroke than how it was done before, so that's a win right there!

Alternatively, you can also just use your cursor keys (to me this is easier, even if it's more keystrokes):

  • (down arrow once) for Row Above
  • (down arrow twice) for Row Below
  • Hit (Enter).

Hope this helps!