Thursday, January 27, 2011

Excel Shortcut to insert a New Row

Excel short cust to insert a row

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

No comments: