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
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.