Insert a Row with a Keyboard Shortcut

I wrote before about inserting rows with VBA. This time, I will show you how you can insert a new row using keyboard shortcuts.

There are three methods you can do it.

Option 1:

Select a cell and then choose Ctrl + Space to select the entire row.

Use Ctrl + Shift + + to insert a new row.

Option 2:

Choose a cell and press Ctrl + Shift + +

A new window will appear. Choose Insert entire row.

Press Enter.

Option 3:

In the last method, choose a cell and press the buttons, one after another: Left AltIR.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.