Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Insert Row in Excel (7 Quick Ways)

The corporate world is dynamic and changing fast along with the expanding technology. Keeping track is important to analyze the changes and plan accordingly. For this, a database plays a vital role. Excel is one of the most famous platforms to create and maintain a database. Maintaining a database involves continuous updating. Adding rows to create a new place for expanding the database is a common thing. The focus of this article is to explain how to insert row in Excel.

how to insert row in excel


Download Practice Workbook

You are welcome to download the practice workbook from here.


7 Quick Ways to Insert Row in Excel

In order to explain some of the common methods of how to insert a row in Excel, I have created a dataset. For the dataset, let’s consider a company that is growing fastly. The company maintains a database of its employees. The dataset contains the name of Departments, Employee Names, and Joining Dates.

Along with the growth of the company, it is also hiring new employees to expand the company and maintain proper work distribution. For this reason, the company needs to add new rows in its database to keep the details of newly hired employees.

Dataset for Showing How to Insert Row in Excel


1. Use Context Menu to Insert Row in Excel

In this method, I will use the Context Menu to insert row in Excel. This method will help you to add a row before the selected row easily. Let’s see the steps.

Steps:

  • Firstly, select the row before which you want to insert the row.

Selecting Row for Inserting New Row in Excel

  • Secondly, right-click on the selected row.
  • Thirdly, select Insert.

Selecting Insert Feature to Insert New Rows

  • Finally, you will see that you have inserted a new row before the selected row.

Final Output of Inserting New Row Using Context Menu

Read more: How to Insert a Row within a Cell in Excel


2. Employ Shift Key to Insert Multiple Rows

If you want to insert multiple adjacent rows in Excel, you can employ the Shift key in Excel. Let me show you the steps of this method.

Steps:

  • To begin with, select the row before which you want to insert the multiple rows.

Selecting First Row of Multiple Rows

  • Next, press and hold the Shift key and select the last row. Here, I selected 3 rows because I wanted to insert 3 New rows in the General Management department.

Choosing Multiple Rows to Insert in Excel

  • Then, right-click on the selected rows.
  • After that, select Insert.

Using Insert Feature to Add Multiple Rows in Excel

  • Lastly, you can see that I have added 3 new rows in the General Management department.

Adding 3 New Rows Using Shift Key And Insert Feature in Excel


3. Apply Ctrl Key to Add Non-Adjacent Rows in Excel

You can also use the Ctrl key to add Non-Adjacent rows in Excel. In this method, I will show you how you can apply the Ctrl key to insert a row in Excel. I will add a new row in the General Management, Operations, and Sales departments. Let’s see the steps of this method.

Steps:

  • In the beginning, select the first row before which you want to add the new row.

Selecting First Row of Multiple Non-Adjacent Rows to Insert New Row Using Ctrl Key in Excel

  • Then, press and hold the Ctrl key and select the other rows before which you want to add new rows.

Using Ctrl Key to Select Multiple Non-Adjacent Rows in Excel

  • Afterward, right-click on any of the selected cells.
  • Then, select Insert.

Using Insert Feature to Insert Non-Adjacent Rows

  • In the end, you can see that I have inserted new rows in the General Management, Operations, and Sales departments.

Inserting New Rows in Every Department


4. Use Insert Feature to Add Row in Excel

Here, I will use the Insert command to add a new row in Excel. The Insert command is used to insert new rows, columns, and cells. In this method, I will use this command to add a new row in the Operations department. Let me show you the steps.

Steps:

  • Firstly, select the row before which you want to add the new row.
  • Secondly, go to the Home tab.
  • Thirdly, select the drop-down option for Insert.

Selecting Drop-down Option for Insert to Add New Row in Excel

  • After that, select Insert Sheet Rows.

Selecting Insert Sheet Rows to Add Row in Excel

  • Finally, you can see that I have added a new row in the Operations department.

Adding New Row in the Operations Department


Similar Readings:


5. Utilize Insert Dialog Box to Include New Row in Excel

You can also use the Insert dialog box to add a new row in Excel. In this method, you won’t have to select an entire row before adding a new row. You can just select a cell from the row before which you want to add a new row. Let’s see the steps of this method.

Steps:

  • In the beginning, select a cell before which you want to add the new row.

Selecting Cell to Insert Row Before It in Excel

  • Next, press Ctrl + Shift + Plus Sign (+) on your keyboard, and the Insert dialog box will open.
  • Select the Entire row.
  • Then, select OK.

Selecting Entire Row on Insert Dialog Box to Add New Row in Excel

  • Finally, you can see that I have added a new row.

Including New Row Using Insert Dialog Box


6. Employ Keyboard Shortcut to Insert Row in Excel

Here, I will show you how to use the keyboard shortcut to insert row in Excel. You can use this method to add new rows quickly and easily. Let me show you the steps.

Steps:

  • First, select the row before which you want to insert a new row.
  • Next, press Ctrl + Shift + Plus Sign (+) on your keyboard.

Using Keyboard Shortcut to Insert New Row in Excel

  • Now, you will see that you have added a new row in your preferred location.

Final Output of Employing Keyboard Shortcut to Insert Row in Excel


7. Insert Row Using Alt Key in Excel

You can also use the Alt key in the keyboard shortcut to Insert a row in Excel. By using this method you can insert a new row by selecting a single cell from the row before which you want to add it. Let’s see the steps.

Steps:

  • In the beginning, select a cell before which you want to add the new row.
  • Then, select Alt + I + R on your keyboard.

Using Alt Key to Insert New Row in Excel

  • In the end, you will see that you have added a new row.

Final Output of Employing Alt Key to Insert New Row in Excel


Things to Remember

  • You have to remember that you have to select the row before which you want to insert new rows.
  • You can add more than one row in all of these methods. For this, you will just have to select the number of rows you want to insert in the first step and the rest of the steps remain the same.

Practice Section

Here, I have provided a practice sheet for you to practice how to insert row in Excel.

Practice Section to Insert Row in Excel


Conclusion

The article explains some of the most common methods of how to insert a row or multiple rows in Excel. You can complete your task of inserting a new row in your dataset by following the steps precisely. For more articles like this stay connected with ExcelDemy. If you have any questions, feel free to let me know in the comment section below.


Further Readings

Syeda Fahima Nazreen

Syeda Fahima Nazreen

Hello People! This is Syeda Fahima Nazreen. I have completed my Bachelors in Science in Electrical and Electronic Engineering. I love to do research and work anything related to technology which includes research and development. I feel great to share my knowledge with you people and your thoughts and opinions about my writing is highly appreciated by me.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo