Insert row in Excel shortcut

Release Dec 3, 2021Update Aug 24, 2022
Written in Excel for Microsoft 365 version 2202

To insert an empty row in Excel, you need to right-click, but if you use shortcut keys, you can save time by eliminating the right-click action.There are so many opportunities to insert rows, so let’s learn some simple shortcut keys to improve our productivity.

Insert row shortcut

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

Insert single row

This is a way to insert a single row using a shortcut key.

Total Time: 1 minute

Select a cell

Select the cell in the row you want to insert.

Select the entire row

Press Shift + Space to select the entire row.

Row insertion complete

Press Ctrl + Shift + + (plus) to insert a row.

Inserting a row from the Insert dialog box

Select the cell in the row you want to insert. Press Ctrl + Shift + + (plus).

The Insert dialog box will appear.

Use the ↓ (Down Arrow key) to select the Entire row, and press Enter.