Many people know how to insert a single row in Microsoft Excel.
Sometimes, you may need to insert multiple rows at a time. Inserting each row by itself can be very time-consuming. Luckily, there are various simple methods you can use to insert numerous rows into a spreadsheet.
3 Methods of inserting multiple rows in Microsoft Excel:
- Repeating the insert function with the F4 key
- Inserting multiple consecutive rows
- Inserting multiple rows in different locations
Let us begin!
Method #1: Repeating the Insert Action with the F4 Key
The F4 key is a shortcut for repeating an action. You can use the F4 key to repeat different tasks. This method works by inserting a single row and the pressing the F4 key to repeat that action. But first, let’s use this method to insert multiple rows.
Step #1: Insert a row
Right-click on the extreme left row number where you want to add a new row.
Next, click Insert from the drop-down menu.
Alternatively, you can use a shortcut – to insert a row using a shortcut, press Alt + I, R on your keyboard.
Step #2: Press the F4 key
Press the F4 key on your keyboard. Pressing F4 will repeat your last action.
In our example, the F4 key was pressed twice giving us two new rows.
Method #2: Inserting Multiple Consecutive Rows
This method inserts multiple rows but in the same location.
Step #1: Select multiple rows
Click with your mouse on the starting row where you want to add more rows.
While holding the button down, drag your mouse over the row numbers where you want new rows to be added.
So if you want 3 more rows, you will select three current rows.
Step #2: Insert rows
Right-click on the row number of the rows you have selected.
From the drop-down menu that appears, click Insert.
Alternatively, you can use a shortcut. To insert a row using a shortcut, press Alt + I, R on your keyboard.
Method #3: Inserting Multiple Rows in Different Locations
In contrast to Method #2, this method will help you insert rows in numerous different places simultaneously.
Step #1: Select multiple rows
Do the following to select multiple rows in different locations:
- Press and hold the CTRL key on your keyboard.
- Next, click on the number to the extreme left of the rows you want to select.
You will see that the selected rows are darkened.
Step #2: Insert rows
Right-click on the row number of any of the selected rows.
Next, click Insert from the drop-down menu.
Alternatively, you can use a shortcut. To insert a row using a shortcut, press Alt + I, R on your keyboard.
Wrapping up
Inserting a single row multiple times can be tiring. The methods above will help you add several rows in a short time. And, of course, the procedures are easy too.
Keep these methods in mind as they will help improve your efficiency. Also, you can use these methods when doing other tasks with Microsoft Excel. For example, you can use the F4 key to keep repeating tasks.