Insert multiple rows in Excel shortcut

• Release Jan 24, 2022Update Aug 24, 2022
• Written in Excel for Microsoft 365 version 2202

You can insert rows one by one, but there is no need to repeat the process. With a few simple steps, you can insert multiple rows into an Excel sheet. To do this, you need to select multiple rows before inserting them. There are various ways to select multiple rows, and I will introduce them in order.

Insert multiple rows shortcut

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

Mac
command + shift + + (plus)

Use the Shift key to insert multiple rows

With this method, you can insert rows by selecting multiple adjacent rows with the Shift key.

Total Time: 1 minute

Select a cell

Press Shift + Space to select the entire row.

Select multiple rows

Press Shift + ↓ (Down Arrow key) to select multiple rows.

Inserting multiple rows

Press Ctrl + Shift + + (plus) to insert multiple rows.

Repeat the operation with the F4 key to insert a row

Press Shift + Space to select the entire row.

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

Press F4 key multiple times will insert as many rows as you press.

Insert a row at a distance

Hold down Ctrl and click on the row number.

Press Ctrl + Shift + + (plus) to inserts a row at the specified row number.

Inserting multiple rows using a name box

The use of the name box is useful when selecting many rows at once.

Select the cell in the row you want to insert.

Enter the range of rows you want to select in the Name box.
ex) 4:14

When you have finished typing, press the Enter key.

Rows 4 through 14 have been selected.

Press Ctrl + Shift + + (plus) to insert multiple rows.