Keyboard shortcuts in Google Sheets for inserting a new row:

In Chrome on Windows or Linux:
  • Alt + I, then R
In IE or Firefox on Windows or Linux:
  • Alt + Shift + I, then R
On a mac:
  • Ctrl + Option + I, then R

Just remember I for Insert and R for row.
2
LVL 7

Expert Comment

by:Brian Matis
Nice! That is super-handy. And it looks like once you've used a keyboard shortcut to bring up one of the menus, you can use arrows keys to move around between all the menus.
1
LVL 7

Expert Comment

by:Brian Matis
It's funny... I'm incredibly used to using keyboard shortcuts at the OS level and in desktop apps, but I often don't think to check for keyboard shortcuts in web apps. JIRA has been the one major exception—at some point early on in my use of it, they did a good job of encouraging shortcut usage—but this is a great reminder to investigate keyboard shortcut support in other common web apps.
0
LVL 12

Author Comment

by:Brandon Lyon
I just got tired of right clicking and selecting insert new line all the time. It's an operation I do frequently on one of my sheets in particular.
1

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month