Google-sheets – Can a button be added to Google Drive (Sheets) toolbar

google sheetskeyboard shortcuts

I use Google Drive Sheets for spreadsheet budget management.

I am frequently using the Insert > Row Above/Below menus.

I don't find any shortcut for either menu option in the Keyboard Shortcuts index, nor is there a related toolbar button.

Is there any way to add a toolbar button for this menu item, or to create a keyboard shortcut for this functionality?

Best Answer

You can right click (or ctrl-click for Mac) on the number of the row you wish to insert above or below, and select Insert 1 Before or Insert 1 After.

Similarly, you can select n number of rows and follow the process above to add n rows above or below the cursor.

For the keyboard shortcuts (assuming Google Chrome)

  • On a PC: Alt+I, R for above; Alt+I, W for below
  • On a Mac: Ctrl-Option-I, R for above; Ctrl-Option-I, W for below.