How to Insert Row in Excel (7 Methods)

Dataset Overview

In this dataset, let’s focus on a rapidly growing company. The company maintains an employee database that includes department names, employee names, and joining dates. As the company continues to expand, it hires new employees to ensure proper work distribution. Consequently, the company needs to add new rows to its database to record the details of newly hired employees.

Dataset for Showing How to Insert Row in Excel

Method 1 – Use the Context Menu

Select the row before which you want to insert a new row.

Selecting Row for Inserting New Row in Excel

Right-click on the selected row.
Choose Insert.

Selecting Insert Feature to Insert New Rows

A new row will be added 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

Method 2 – Shift Key for Multiple Rows

Select the row before which you want to insert multiple adjacent rows.

Selecting First Row of Multiple Rows

Hold down the Shift key and select the last row.

Choosing Multiple Rows to Insert in Excel

Right-click on the selected rows.
Select Insert.

Using Insert Feature to Add Multiple Rows in Excel

New rows will be added in the selected range.

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

Method 3 – Ctrl Key for Non-Adjacent Rows

Select the first row before which you want to add a new row.

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

Press and hold the Ctrl key.
Select other rows where you want to insert new rows.

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

Right-click on any of the selected cells.
Choose Insert.

Using Insert Feature to Insert Non-Adjacent Rows

New rows will be inserted in the specified locations.

Inserting New Rows in Every Department

Method 4 – Insert Feature

Select the row before which you want to add a new row.
Go to the Home tab.
Click the drop-down arrow next to Insert.

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

Select Insert Sheet Rows.

Selecting Insert Sheet Rows to Add Row in Excel

A new row will be added.

Adding New Row in the Operations Department

Similar Readings:

Method 5 – Insert Dialog Box

Select a cell before which you want to add a new row.

Selecting Cell to Insert Row Before It in Excel

Press Ctrl + Shift + Plus Sign (+) on your keyboard.
The Insert dialog box will open.
Choose Entire row and click OK.

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

A new row will be inserted.

Including New Row Using Insert Dialog Box

Method 6 – Keyboard Shortcut

Select the row before which you want to insert a new row.
Press Ctrl + Shift + Plus Sign (+) on your keyboard.

Using Keyboard Shortcut to Insert New Row in Excel

A new row will be added in your preferred location.

Final Output of Employing Keyboard Shortcut to Insert Row in Excel

Method 7 – Alt Key

Select a cell before which you want to add the new row.
Press Alt + I + R on your keyboard.

Using Alt Key to Insert New Row in Excel

A new row will be added.

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

Things to Remember

Remember to select the row before which you want to insert new rows.
You can also add multiple rows using these methods by selecting the desired number of rows in the first step.
The subsequent steps remain the same.

Practice Section

We have provided a practice sheet for you to practice how to insert rows in Excel.

Practice Section to Insert Row in Excel

Download the Practice Workbook

You can download the practice workbook from here:

Inserting Rows.xlsx