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

**Table of Contents**hide

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

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

**Similar Readings**

**How to Insert Row Below in Excel****How to Insert Rows in Excel Automatically****How to Insert Multiple Rows After Every Other 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.

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

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

## Practice Section

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

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

**How to Insert a Row Within a Cell in Excel****Excel Insert Blank Row Every Nth Row****How to Insert a Total Row in Excel****How to Insert Multiple Rows in Excel****Excel Formula to Insert Rows Between Data****How to Insert Multiple Blank Rows in Excel****Cannot Insert Row in Excel****Excel Fix: Insert Row Option Greyed Out in Excel****Excel VBA: Insert Row with Values****Excel VBA Insert Rows Based on Cell Value****Macro to Insert Row in Excel Based on Criteria****Excel Macro Add Row to Bottom of Table****Macro to Insert Multiple Rows in Excel****Excel Macro Insert Row and Copy Formula**