Excel Hack

Insert multiple rows in Excel shortcut

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

Select the entire row

Press Shift + Space to select the entire row.

Select multiple rows

Select multiple rows

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

Inserting multiple rows

Insert multiple rows

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

Repeat the operation with the F4 key to insert a row

Select the entire row

Press Shift + Space to select the entire row.

Insert a row

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

Insert multiple rows

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

Insert a row at a distance

Multiple selection of any row

Hold down Ctrl and click on the row number.

Insert the specified row

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

Select the cell in the row you want to insert.

Specify the range of rows to select in the Name box

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.

Select a range of selected rows

Rows 4 through 14 have been selected.

Inserting multiple rows

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