If Right-clicking on a row and selecting insert is too time consuming for you and you dont want to take your hands off the keyboard. You can insert a new row above the current row using only the keyboard!


Q: Is there an easy way to insert new rows in Excel using a keyboard?

A: Yes


The following keyboard shortcut will insert one row above the active row:

Press Alt + I (Insert), then press R (Row).

Use the Keyboard Right-Click Key to emulate a right-click on the current selection.

On Windows I use:

  1. Shift + Space to select the current row.
  2. Keyboard Right-Click Key + I to insert a row.

(*) The Keyboard Right-Click Key looks like this: