How to Insert a New Row in Excel (Top 5 Methods)

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 EmployeesCountry, and Joining Date.

dataset of excel


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.

Insert a New Row in Excel

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.

Insert a New Row in Excel

  • Now press ALT +  I  +  R from your keyboard and wait for the magic.

Insert a New Row in Excel

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

Insert a New Row in Excel

  • Now click on the right button of the mouse.

Insert a New Row in Excel

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

Insert a New Row in Excel

  • 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


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

Insert a New Row in Excel

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

Insert a New Row in Excel

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.

Insert a New Row in Excel

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

Insert a New Row in Excel

  • Hence, it will insert a new row.

Insert a New Row in Excel

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.

Insert a New Row in Excel - Practise


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

Foyez

Foyez

Hello everyone, This is Foyez Alam. I have recently completed my MBA from Institute of Business Administration (IBA), University of Dhaka. Earlier I have completed my B.Sc in Leather Engineering from University of Dhaka. Now I am working as an Excel and VBA Content Developer in SOFTEKO. Through patience and hard work, I have a passion for learning new things and applying my knowledge to new situations. That's why I am here. Besides this, I love to interact with different people and I love to spend my spare time reading, watching movies, dancing, etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo