To organize any dataset in Excel, you may need to insert or delete rows or columns. More interestingly, we can insert a single row or column and even multiple rows or columns according to our wish. In this tutorial, we are going to learn **how to insert a row in Excel**.

To apply the methods, Iâ€™m going to use a sample dataset that represents information about a particular employee. The dataset has 3 columns; these are **Employees**,Â **Country**, andÂ **Joining Date**.

## Download Practice Workbook

### 1. Insert A New Row Using the Shortcut â€śCTRL + SHIFT + Plus (+) Signâ€ť

You can insert bothÂ **single rows **andÂ **multiple rows** in Excel by using keyboard shortcuts.

#### 1.1. Shortcut for a Single Row

To Insert a row, first, we have to select **an entire row** in an Excel sheet.

Select your desired row from your spreadsheet.

âž¤ We are going to select **row 7** by just clicking on the **row** number which is **7**.

Here, clicking on **row 7** means we want to insert a row before this row representing the information of **Smith**.

Now simply press **CTRL + SHIFTÂ +Â Plus (+) Sign **from your keyboard and letâ€™s see what we find after that.

Here, we can see that after pressing **CTRL + SHIFT + Plus (+) Sign **it inserts an empty row as **row 7,** and the previous **row 7** steps down to **row 8**, along with all other rows under it.

#### 1.2. Shortcut for Multiple Rows

Inserting multiple rows in an Excel sheet is completely similar to inserting a single row. But here, instead of selecting a **single row**, we have to select **multiple rows**, above those we want to insert rows.

- Here we select
**rows 8 & 9**together which means we want to insert two rows before them. *Select as many***rows**as you want to insert.

- Now simply press
**CTRL + SHIFT + Plus (+) Sign**like before from your keyboard and letâ€™s see what we find after that.

- Here, we can see that after clicking
**CTRL + SHIFT + Plus (+) Sign**it inserts two empty rows as**rows 7 & 8**, and the previous**rows 8 & 9**step down to**rows 10 &11**.

**Read More:** **Shortcuts to Insert New Row in Excel (6 Quick Methods)**

### 2. Insert a New Row Using the Shortcut â€śALT + I + Râ€ť

Letâ€™s discuss another method of inserting data. For this, again select a row from the table first.

- Here we select the
**entire row 6**.

- Now press
**ALT +Â IÂ +Â R**from your keyboard and wait for the magic.

- Here, we can see that after clicking
**ALT + I + R**there inserts an**empty row**as**row 6**, and the previous**row 6**steps down to**row 7,**along with all other rows under it.

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

### 3. Insert a New Row Using â€śInsertâ€ť Box

We can also insert a row in an Excel sheet by using the **Insert Box**. It is one of the easiest ways to insert a **row**.

- First, we have to select a
**row**above which we want or insert a**row**. Here we select the**entire row 7.**

- Now click on the
**right button of the mouse.**

- After clicking on the
**right button of the mouse**, there appears a**context menu bar**. From the**context bar**, simply click on the**insert**option and wait for the magic.

- Here, we can see that after clicking on the
**insert**option, there inserts an empty**row**as**row 7,**and the previous**row 7**steps down to**row 8**, along with all other**rows**under it.

**Read More:**** Excel Macro to Insert Rows (8 Methods)**

**Similar Readings**

**Excel Macro to Add Row to the Bottom of a Table****How to Insert a Total Row in Excel (4 Easy Methods)****How to Insert Multiple Blank Rows in Excel (4 Easy Ways)****Cannot Insert Row in Excel (Quick 7 Fixes)****Macro to Insert Multiple Rows in Excel (6 Methods)**

### 4. Using Context Menu to Insert a New Row

We can also insert a **row** just by selecting any cell from our working sheet by using the **context menu**.

- Here, we will select
**cell D7**

- After clicking on the
**right button of the mouse**on**cell D7**, there appears a**context menu bar**. From**the context menu bar,**now we are going to click on the**insert option.**

- Now clicking on the
**insert**option, there appears another context menu bar. From there, we have to select the**entire row.** - Then, click
**OK**.

- Hence, it will
**insert**the desired**empty row.**

**Read More:** **How to Insert Rows Automatically in Excel (3 Ways)**

### 5. Using Ribbon to Insert a New Row

Row insert can also be done using only **ribbons** **Home** menu.

- For this, we have to select a
**row** - Here, we select the entire
**row 6**.

- Now, Open the
**Home**tab >> go to**Cells**>> from**Insert**>> select**Insert Sheet Rows**

- Hence, it will insert a new
**row**.

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

## Things to Remember

đź”ş In case you want to **insert 3, 4, or more rows** in an Excel sheet, you have to select that particular number of **rows** first and then apply keyboard shortcuts or **ribbon** options.

## Practice Section

Iâ€™ve given a practice sheet in the workbook to practice these explained ways to insert rows. You can download it from the link given above.

## Conclusion

In this article, I have tried to explain 5 different ways to insert a new row in Excel. Note that, you can also insert multiple rows in Excel by just following the same methods. Last but not least, I will be extremely grateful if you comment down below any of your suggestions, ideas, or feedback.

**Related Articles**

**How to Insert Multiple Rows After Every Other Row in Excel****How to Move a Row in Excel (6 Methods)****Excel Formula to Insert Rows between Data (2 Simple Examples)****Excel Fix: Insert Row Option Greyed out (9 Solutions)****How to Insert Blank Row After Every nth Row in Excel (2 Easy Methods)****How to Insert a Row within a Cell in Excel (3 Simple Ways)**