Excel Insert Multiple Rows

Insert Multiple Rows in Excel (Table of Contents)

• Example #1 – Insert a Single row using a mouse
• Example #2 – Insert Multiple rows using Mouse shortcut

Insert Multiple Rows In Excel

Insert Multiple Rows in excel is used when we need to insert multiple rows at a time. For this, please choose the number of rows we want to insert. Suppose, if we want to insert 4 rows at a time, then first select 4 rows in sequence and then click on the right to select Insert. There is another way for that; also, first, select the number of rows we want to insert, then press Ctrl + Shift + “+” (Plus) together.

How to Insert Multiple Rows in Excel?

There are multiple ways of inserting multiple rows in excel. How to do this, we will learn step by step with examples.

Example #1 – Insert a Single row using a mouse

Let’s consider some stationary data:

For inserting a single row using a mouse shortcut, follow the below steps:

• Where you want to insert a new row, select the whole row below of that point. For example, if you want to insert a row between the 7^th & 8^th row, select the 8^th row and do right-click, a drop-down list will open. Click on the insert option as below screenshot:

• It will insert a blank row below the 7^th

Example #2 – Insert Multiple rows using Mouse shortcut

Let’s take the same stationary data:

With the use of the mouse, we can insert multiple rows at a time. Follow the below steps:

• Select the number of rows below the row where you want to insert the rows. For Example, if you want to insert the 4 rows below row no. 3, then select the rows from row no. 4 to row no. 7.Refer to the below screenshot:

• Do right-click. Drop down list will open. Click on the insert option.

• It will insert the 4 rows below row no. 3 as below screenshot.

Insert rows by using Excel Ribbon:

• Select the row and go to the HOME tab. Click on the INSERT option under the Cells section. Refer to the below screenshot:

• It will open a drop-down list. By clicking on Insert Sheet Rows

•  It will insert a row above the selected row.

Insert rows by using Keyboard shortcut:

• Select the row below (where you want to insert the row) by using the keyboard shortcut SHIFT-SPACEBAR of the keyboard.
• The whole row will be selected.
• Press the SHIFT-CTRL-+ sign for inserting a row.

Using insert copied cells option:

• It’s a quick way to insert multiple rows in excel. Select the blank row.

• Copy it & Select the above rows where you want to insert the new row. If you want to insert multiple rows, select the number of rows. We want to insert 3 rows; hence, we have selected the 3 rows. Refer to the below screenshot:

• Do right-click. Drop down list will open. Click on the Insert Copied Cells option.

• It will insert the multiple rows as we want as per the below screenshot.

Things to Remember

• The keyboard shortcut is the easiest way to insert the rows in a worksheet.
• It saves a lot of time in excel while creating reports or working with huge data.

Recommended Articles

This has been a guide to the Insert Multiple Rows in Excel. Here we discuss the Insert Multiple Rows in Excel and how to create the Insert Multiple Rows in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –

1. VBA Insert Row
2. Add Rows in Excel Shortcut
3. ROWS Function in Excel
4. How to Sum Multiple Rows in Excel