Shortcuts to Insert New Row in Excel (6 Quick Methods)

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.

How to Insert New Row in Excel Shortcut


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.

Insert a New Row Using ALT + I + R Keyboard Shortcut

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.

Read More: How to Insert a New Row in Excel (Top 5 Methods)


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.

Insert Multiple New Rows Using ALT + I + R Shortcut

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.

Read More: Macro to Insert Multiple Rows in Excel (6 Methods)


Method 3: Insert a New Row Using CTRL + SHIFT + Plus(+) 

How to Insert New Row in Excel Shortcut

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.

Insert a New Row Using CTRL + SHIFT + Plus(+) Shortcut

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.

Enter a New Row Using CTRL + SHIFT + Plus(+) Shortcut

Read More: How to Insert Row in Excel ( 5 Methods)


Similar Readings


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.

Insert Multiple New Rows Using CTRL+SHIFT+ Plus (+) Keyboard Shortcut

Then we will use keyboard shortcut CTRL + SHIFT + Plus(+) to insert three(3) new rows above row 7.

Read More: How to Insert Multiple Rows in Excel (6 Easy Methods)


Method 5: Insert a New Row in Excel Using VBA

You can insert a new row using VBA.

To use the VBA editor,

Open the Developer tab >> select Visual Basic

Insert a New Row Using VBA

A new window will open.

Go to Insert and select Module.

Go to Insert and select Module

A new Module will open.

How to Insert New Row in Excel Shortcut

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.

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

Insert Alternative New Rows Using VBA

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.

Read More: Excel Formula to Insert Rows between Data (2 Simple Examples)


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.


Practice Section

I’ve provided a practice section to practice these explained methods.

Practice section


Conclusion

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.


Related Articles

Lutful Hamid
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo