Rows run horizontally along the worksheet. In Excel rows are denoted by numerical values like 1,2,3,4 etc. In this tutorial we will see 6 methods to insert new row in Excel shortcut. We will use keyboard shortcuts here so that we can work quickly and improve productivity as well as efficiency.
Here we have a dataset that contains a list of sold items that represents the sales record of an electric shop. The dataset has 3 columns; these are Date, Product, and Invoice No. We will learn to insert new row in Excel shortcut using this worksheet.
Download practice workbook
6 Quick Methods to Insert a New Row in Excel
Suppose, the shop owner has mistakenly forgotten to make an entry and he wishes to make it now. He will need to insert a new row to the record.
Suppose, he has made an additional sale on the 26th of January which he forgot to insert. He wants to insert it now.
He will need to insert the new row between row 6 and row 7.
Method 1: Insert a New Row in Excel Using ALT + I + R
First, select the row above which you want to enter the new row. You can do this by clicking the left most side number denoting the row.
Or you can use the keyboard shortcut SHIFT + Spacebar. Pressing SHIFT + Spacebar will select the row of the active cell.
Pressing SHIFT + Spacebar while B7 cell is activated will select the entire row 7.
Then press ALT + I + R to insert a new row above.
Method 2: Insert Multiple New Rows Using ALT + I + R
If you want to insert multiple rows you will need to select the same number of rows. Then press ALT + I + R to insert new rows above.
Suppose we want to insert 3 new rows above row 7. We select rows 7,8,9 first. Then press Alt + I + R.
Here, we will get 3 new rows above row 7.
Method 3: Insert a New Row Using CTRL + SHIFT + Plus(+)
Again we want to insert a new row above row 7. Like before we will select row 7 using the left most number denoting the row number or selecting any cell in that row and pressing SHIFT + Spacebar.
We will select the entire row as shown in the picture below.
Then use the keyboard shortcut CTRL + SHIFT + Plus(+) to insert a new row above the row 7.
Read More: How to Insert Row in Excel ( 5 Methods)
- Excel Fix: Insert Row Option Greyed out (9 Solutions)
- How to Insert Blank Row After Every nth Row in Excel (2 Easy Methods)
- Insert a Row within a Cell in Excel (3 Simple Ways)
- How to Insert Row Below in Excel (5 Methods)
- Macro to Insert Row and Copy Formula in Excel (2 Methods)
Method 4: Insert Multiple New Rows in Excel Using CTRL+SHIFT+ Plus (+)
For inserting multiple rows above any row, we will need to select the same number of rows we want to insert.
Suppose we want to insert three(3) rows above row 7. We will select 3 rows below.
Then we will use keyboard shortcut CTRL + SHIFT + Plus(+) to insert three(3) new rows above row 7.
Method 5: Insert a New Row in Excel Using VBA
You can insert a new row using VBA.
Open the Developer tab >> select Visual Basic
A new window will open.
Go to Insert and select Module.
A new Module will open.
Copy the code below and paste it in the Module.
Sub InsertRow_Shortcuts() Range("B7").EntireRow.Insert End Sub
First, we will have to mention the cell reference (B7). Then using the “Entire Row” property we will select the entire row. Then using the Insert method we will be able to insert an entire row above the selected cell.
To run the code from the Run tab select Run Sub/UserForm. Or you can also use the F5 key to run the code.
Now, you will see a new row above row 7.
Read More: VBA to Insert Row in Excel (11 Methods)
Method 6: Insert Alternative New Rows in Excel Using VBA
Inserting alternate rows in Excel manually can be tiresome. We can use VBA to do it conveniently.
To do so, we will need to insert VBA code following the steps described in the previous Method 5.
Then paste the following code in the module.
Sub InsertRow_Shortcut() Dim M As Integer Dim N As Integer N = 6 For M = 6 To 14 Cells(N, 2).EntireRow.Insert N = N + 2 Next M End Sub
Here, in the Sub InsertRow_Shortcut, I declared two variables, M and N as Integer types.
Then, used For loops to insert a row in every alternate row. I used the EntireRow property and the Insert method to insert a new row.
Now, save the code and to run the code you can press F5.
Hence, it will insert new row in every alternate row.
Things to remember
If your Excel sheet does not show the Developer tab follow this link to see how the developer tab can be added.
When inserting new rows always keep in mind that the new row will be inserted above the row you have selected.
So, keep in mind to select the row below which you wish to insert the new row.
I’ve provided a practice section to practice these explained methods.
In this article, I tried to explain all possible shortcuts to insert new row. You will get 6 methods to insert new row in Excel shortcut. These shortcuts can be handy while inserting new rows. These will improve your speed and efficiency. Practice and master these shortcuts. For any type of comment or feedback feel free to reach out to us. Our team will be more than happy to help you out with any Excel-related problem.