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.
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.
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.
- Secondly, right-click on the selected row.
- Thirdly, select Insert.
- Finally, you will see that you have inserted a new row before the selected row.
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.
- 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.
- Then, right-click on the selected rows.
- After that, select Insert.
- Lastly, you can see that I have added 3 new rows in the General Management department.
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.
- Then, press and hold the Ctrl key and select the other rows before which you want to add new rows.
- Afterward, right-click on any of the selected cells.
- Then, select Insert.
- In the end, you can see that I have inserted new rows in the General Management, Operations, and Sales departments.
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.
- After that, select Insert Sheet Rows.
- Finally, you can see that I have added a new row in the Operations department.
Similar Readings:
- How to Insert Blank Row After Every nth Row in Excel
- How to Insert Multiple Rows After Every Other Row in Excel
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.
- Next, press Ctrl + Shift + Plus Sign (+) on your keyboard, and the Insert dialog box will open.
- Select the Entire row.
- Then, select OK.
- Finally, you can see that I have added a new row.
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.
- Now, you will see that you have added a new row in your preferred location.
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.
- In the end, you will see that you have added a new row.
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.
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
- How to Insert Rows Automatically in Excel (3 Ways)
- How to Move Rows in Excel (4 Simple & Quick Methods)
- Excel Macro to Add Row to the Bottom of a Table
