Excel Hack

Insert row above shortcut

I will introduce a shortcut key to insert a blank line above a cell in Excel. I will also show you how to insert a blank line every other line, so please refer to that as well. Let’s take this opportunity to learn some useful shortcuts to improve our work efficiency.

Insert a row above with the shortcut key

Windows
With numeric keypad: Ctrl + + (plus)
Without numeric keypad: Ctrl + Shift + + (plus)
Access Key: Alt + I + R

Mac
command + shift + + (plus)

Insert a row above a cell

This section explains how to insert a new row on top of a cell using shortcut key.

Total Time: 1 minute

Select a cell

Select a cell

Select the cell you want to insert a row above.

Select a row

Select a row

Press Shift + Space to select a row.

Inserted a row on top

Inserted a row on top

Press Ctrl + Shift + + (plus) to insert a row above. Or Press Alt + I + R.

Insert a blank row every other row

Select a cell

Select the cell you want to insert a row above.

Select a row

Press Shift + Space to select a row.

Select a row

Hold down Ctrl to select the cell one row down, and Shift + Space to select the row.

Select a row

Follow the same procedure to select multiple rows that you want to insert a row on top. Press Ctrl + Shift + + (plus).

We can now insert a row every other row

We can now insert a row every other row.