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

Get FREE Advanced Excel Exercises with Solutions!

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


Insert a New Row in Excel with Shortcut: 6 Quick Methods

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 Row Below in Excel


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: How to Insert Multiple Blank Rows in Excel


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 a Total Row in Excel


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: Insert Multiple Rows After Every Other Row in Excel


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: How to Insert Rows in Excel Automatically


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 Insert Blank Row Every Nth Row


Things to remember

If your Excel sheet does not show the Developer tab, we have to enable the developer tab from the ribbon.

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


Download Practice Workbook


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


<< Go Back to Insert Rows | Rows in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Lutful Hamid
Lutful Hamid

LUTFUL HAMID is an outstanding marine engineer who finds joy in navigating the realms of Excel and diving into VBA programming. To him, programming is like saving time when dealing with data, files, and the internet. His skills extend beyond the basics, covering Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he's shifted gears and now serves as a content developer. In this role,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo