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!