17

After 1/2 hour of googling to no avail, I am ready to ask this here: As the title says, what is the hotkey for adding/removing rows in an already existing table in Google Docs?

It seems excessively tedious to just keep going through the menu and adding rows one by one.

1

8 Answers 8

30

Pressing Tab when the cursor is at the rightmost of the bottom row automatically adds a new row below it. It's quite handy if you don't know how many rows you need in advance and require them as you type along.

Pressing the Tab key at the LAST CELL of a row, for those working in a table

1
  • I appreciate you!
    – Phillip
    Nov 23, 2020 at 21:16
9

if you are with Chrome browser:

  • press LEFTALT + O + 2 + B for adding row below
  • or press LEFTALT + O + 2 + A for adding row above
  • press LEFTALT + O + 2 + E for deleting a row

if you are with an alternative browser:

  • press LEFTALT + SHIFT + O + 2 + B for adding row below
  • or press LEFTALT + SHIFT + O + 2 + A for adding row above
  • press LEFTALT + SHIFT + O + 2 + E for deleting a row

NOTE: 2 not NUM2

3
  • 1
    Usually a + is used to say that the keys should be pressed at the same time. I don't know if there a standard notation to use for keyboard pressing steps, but maybe a comma as it means pause, could be better than + On the first bullet, left alt and O keys should be pressed simultaneously, but once the Format menu is open then they could be released. Aug 10, 2018 at 15:27
  • @Rubén agreed, but it works even if pressed like presented
    – user0
    Aug 10, 2018 at 15:32
  • I'm sorry if appeared that I was saying that the key sequences doesn't work, that was not my intention. Do you see yourself pressing five keys at the same time to insert a row? I don't see myself doing that :) Aug 10, 2018 at 15:36
6

You can add a new row once (from the menu), then repeat the action by pressing CMD + Y:

enter image description here

1
  • That works but is the most non-standard implementation of "redo" that I've ever seen; it usually only operates on commands that you've undone. Jun 10, 2021 at 23:04
3

Short answer

There isn't Summary of answer: Use Left Alt + O to open the Format menu, then the keys shown underlined or parenthesis enclosed.

Explanation

Keyboard shortcuts are shown in menus, contextual menus and by (on Windows) pressing Ctrl + /

The above doesn't show a keyboard shortcut to insert rows on Google Docs documents but there is a keyboard sequence that could be used to do that. Just look to the menu for underlined letters or keys shown parenthesis enclosed.

Suggested action

Send feedback to Google

1
  • Wow, ok. Fail on googles part! >< Aug 9, 2018 at 17:56
1

Right click and select 'insert row below'. Press Ctrl + Y to add multiple rows

0

Click on the table and then press Tab.

0

In Chrome it's Alt + I, R, arrow up/down to insert new row above or below.

-1

Google Sheets's native way of doing this requires a lot of keystrokes as described elsewhere, but you can now easily record a macro doing the action, in this case inserting a row (Under Extensions->Macros) and assign it a single key command (and modify the source as needed).

Here is what my modified macro (to insert multiple rows) looks like:


function myFunction1() {
  var spreadsheet = SpreadsheetApp.getActive();
  var numRows = spreadsheet.getActiveRange().getNumRows();
  spreadsheet.getActiveSheet().insertRowsAfter(spreadsheet.getActiveRange().getLastRow(), numRows);
  spreadsheet.getActiveRange().offset(numRows, 0, numRows, spreadsheet.getActiveRange().getNumColumns()).activate();
};

Since this is also likely relevant to people finding this, here is the (unmodified) macro to delete rows:

function myFunction() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());
};
1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.