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:


Further Readings

Get FREE Advanced Excel Exercises with Solutions!
Syeda Fahima Nazreen
Syeda Fahima Nazreen

SYEDA FAHIMA NAZREEN is an electrical & electronics engineer who loves exploring Excel and VBA programming. To her, programming is a time-saving tool for dealing with data, files, and the internet. She's skilled in Proteus, MATLAB, Multisim, AutoCAD, Jupiter Notebook, and MS Office, going beyond the basics. With a B.Sc in Electrical & Electronic Engineering from American International University, Bangladesh, she's shifted gears and now works as a content developer. In this role, she creates techy content exclusively... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo