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

## 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 **+ **Spaceba**r 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.

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(+)

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

**Similar Readings**

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

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

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

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

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