Excel Tip: Keyboard shortcut to insert a row

I needed to know how to add a row to a spreadsheet I was working on, and thankfully Joe Witwer, author of this Excel tip, figured this out. While not exactly straightforward, it’s easy enough to add a row quickly. He also includes instructions regarding how to insert a column:

Excel Tips: Insert a New Row or Column – Excel Keyboard Shortcut:

Lately, I have been trying to use as many Excel keyboard shortcuts as I can (not only for productivity, but for ergonomic reasons). I haven’t found a quick keyboard shortcut to insert a new row or column, but there is a two-step process that is quite convenient:

  • Shift+SpaceBar = Select the current row
  • Ctrl+Shift+PlusSign = Insert row(s)

To insert a new column, in step 1 use Ctrl+SpaceBar to select the current column. To insert more than one row or column at a time, use the arrow keys as you hold Shift before going to step 2.

Hope this helps!