How do I insert a new row in Excel via the keyboard?

Question

Right clicking on a row and clicking insert is fairly time consuming. I'd rather not have to take my hands off the keyboard. How can I insert a new row above my current row using only the keyboard? I'm primarily interested in inserting a single row at a time, but would also be interested in answers that address multiple lines at a time.

Answer 1

The hotkey to add new rows is ctrl and + (on the num pad) or ctrl shift + (on the number bar on your qwerty keyboard)

To add multiple rows at a time, you have to highlight x amount of existing rows and use the hotkeys stated above. You can't avoid point and click for multiple rows. So if you want to add 20 rows, highlight 20 rows and do the hotkeys stated above