Sometimes, you may come across a situation where you want to deal with lots of data and as it updates with time, you may need to **insert multiple empty rows** in your workbook. If you are facing issues to insert multiple blank rows in Excel, you are in a right place. This article will train you how to insert multiple blank rows in Excel in 4 simple and effective ways.

**Table of Contents**hide

## Download Practice Workbook

Download the following Excel file for your practice.

## 4 Quick Ways to Insert Multiple Blank Rows in Excel

Letâ€™s first introduction to the dataset. We have the following dataset which contains **5** rows without headings. Our goal is to insert multiple rows.

### 1. Select Multiple Rows and Insert an Equal Number of Blank Ones

This method can insert an equal number of blank rows as you select. In this example, we want to insert **2** rows above row **7**. Now, follow the steps below.

**Steps:**

- Select the
**7th**and**8th**rows > press**Right-click**> choose the**Insert**option from the**Context**menu.

Here is the result,

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

### 2. Add Multiple Blank Rows Using Name Box

This technique can allow you to insert multiple blank rows even in 1000s in Excel. In this example, we will insert 3 rows below the **5th** row. Now, follow the steps below.

**Steps:**

- Go to the
**Name Box**> In the Name box, type the values in the format**â€śInitial row: Final rowâ€ť**. In this example, type**6:8**. It will select the rows**6th**to**8th.**

- Now, press
**Right-click**on the selected rows, choose**Insert.**

Finally, here is the result,

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

**Similar Readings**

**How to Insert Rows Automatically in Excel (3 Ways)****Insert Multiple Rows After Every Other Row in Excel****How to Move a Row in Excel (6 Methods)****Insert Row in Excel ( 5 Methods)****How to Insert a Row within a Cell in Excel (3 Simple Ways)**

### 3. Insert Multiple Blank Rows Using Hotkeys

If you donâ€™t want to do **Right-clicks** while you are inserting multiple blank rows, there are two **Hotkeys** you can use.

#### 3.1 Press **CTRL+SHIFT+Plus**

Follow the steps below.

**Steps:**

- By using row numbers on the left, select the number of rows equal to the number of blank rows you need to insert. In this example, the
**6th**to**8th**rows are selected below the**5th**row.

- Now, you need to press
**CTRL+Plus**on the numeric part of your keyboard. Otherwise, if you want to use the**â€ś+â€ť**sign from the main keyboard, press**CTRL+SHIFT+Plus.**3 blank rows will be inserted below the**5th**row immediately.

Here is the result,

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

#### 3.2 Press ALT+I+R

Follow the steps below.

**Steps:**

- By using row numbers on the left, select the number of rows equal to the number of blank rows you need to insert. In this example, the
**6th**to**8th**rows are selected below the**5th**row.

- Now, you need to press
**ALT+I+R**successively on your keyboard. 3 blank rows will be inserted below the 5th row immediately.

Here is the result, **Â **

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

### 4. Apply an Excel VBA Code to Insert a Number of Empty Rows

When you are dealing with a large dataset on an Excel sheet that you want to use regularly, you could automate row insertion using **VBA.** You just need to follow the steps below.

**Steps:**

- Go to
**Developer**tab >**Visual Basic**>**Insert**>**Module**. A**M****odule**window will pop up.

If you donâ€™t have the **Developer** tab, you can also get to the **Visual Basic** window by pressing the **ALT+F11** keys.

- Â Write down the following code in the
**M****odule**window.

```
Sub InsertBlankRowsAtCursor()
Answer = InputBox("Input the number of rows to insert (Do not exceed 200)")
NumberofLines = Int(Val(Answer))
If NumberofLines > 200 Then
NumberofLines = 200
End If
If NumberofLines = 0 Then
GoTo EndInsertLines
End If
Do
Selection.EntireRow.Insert
Count = Count + 1
Loop While Count < NumberofLines
EndInsertLines:
End Sub
```

- Exit the
**Code window.** - Now, again go to
**Developer**>**Macros**or press**ALT+F8**. Select the**M****acro**we just made and click on**O****ptions**. - In the shortcut key box, use
**CTRL+SHIFT+H**. Press**OK**.

- Go back to the worksheet and select a cell (
**Cell B6**) below which you need to insert blank rows. - Press the shortcut key
**(CTRL+SHIFT+H)**, and we will see a pop-up window asking us to type the number of rows we like to insert. In this example, type**5**and press**ENTER.**

Finally, here is the result,

**Read More: ****VBA to Insert Row in Excel (11 Methods)**

## Conclusion

In this tutorial, I have discussed 4 quick ways to insert multiple blank rows in excel. I hope you found this article helpful. You can visit our website **Exceldemy** to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.

## Related Articles

**Excel Fix: Insert Row Option Greyed out (9 Solutions)****Cannot Insert Row in Excel (Quick 7 Fixes)****Macro to Insert Row and Copy Formula in Excel (2 Methods)****Excel Macro to Add Row to the Bottom of a Table****How to Insert a Total Row in Excel (4 Easy Methods)****Insert Rows in Excel Based on Cell Value with VBA (2 Methods)****VBA Macro to Insert Row in Excel Based on Criteria (4 Methods)**