How to Insert Multiple Rows in Excel (6 Easy Methods)

Insertion of rows into Excel dataset is quite basic and one of the most frequent tasks we do. Insertion of a single row is super handy but the insertion of multiple rows requires additional steps that we have to perform. In this article, you are going to learn about six super easy methods to insert multiple rows into your dataset in the blink of an eye.

Download Practice Workbook

In this dataset, you will find a list of books with their corresponding writers and prices. There are a total of 7 sheets for you to practice and those are completely free! The Intro sheet is in its rawest form. The remaining 6 sheets are dedicated to the  6 individual methods. 

Download the file from here:

6 Ways to Insert Multiple Rows in Excel

There are several ways to insert multiple rows in Excel. But in this particular article, we are going to discuss 6 methods that you can use to insert multiple columns easily in Excel. Now let’s go through all of them one by one.

    1. Insert Feature

This method is all user interface oriented. You will find this feature under the Home ribbon. If you want to bypass any keyboard shortcuts, then you may use this method to insert multiple rows quite easily. Follow the below steps: 

      Step-1: Select the number of rows you want to insert.

      Step-2: Go to Home >>> Insert >>> Insert Sheet Rows.

      Step-3: Click on Insert Sheet Rows

insert multiple rows in excel using insert feature

That’s it. You’ve successfully inserted 4 rows to the table. Here’s the end result: 

insert multiple rows in excel using insert feature 2

    2. Insert Menu Option

This method is also all user interface oriented just like the previous one. But this one is more handy and easy to use. All you need to do is right-click upon the selected area and then select Insert from the pop-up menu. Let’s learn it step by step: 

      Step-1: Select the number of rows that you want to insert.

      Step-2: Right-click anywhere on the selection area.

      Step-3: Select Insert from the pop-up menu.

insert multiple rows in excel using insert menu option

    3. Access Key Combination

If you like to use keyboard shortcuts, then this method should be your favorite one. Just select the number of rows that you want to insert then use an insertion hotkey. That’s it.

      Step-1: Select the number of rows that you want to insert.

      Step-2: Press ALT + I + R from the keyboard. That’s it.

insert multiple rows in excel using access key combination

    4. Insert Row Keyboard Shortcut

You can use this method in exchange for the previous one. Because this method also uses keyboard shortcuts to insert multiple rows in Excel. Follow the below steps: 

      Step-1: Select the number of rows that you want to insert.

      Step-2: Press CTRL + SHIFT + =. That’s it.

insert multiple rows in excel using row keyboard shortcut

    5. Name Box

Cases arise that you might need to insert 100 rows at a time. Selecting and inserting this many rows at the same time can be intimidating. Here comes the magic trick. You can use the Name Box to select as many rows as you want and insert them into your table. Here’s how to achieve it: 

      Step-1:  Select a cell underneath of which new rows will be inserted.

      In this example, we have selected cell B5

      Step-2: Type the range within the Name Box. 

      As we are intended to insert 100 rows, thus the range is B5 to B105.

      Range:

      B5:B105

insert multiple rows in excel using name box

      Step-3: Hit the ENTER button and all the 100 cells will be selected in column B.

      Step-4: Press SHIFT + SPACE button to select the entire row of the table.

      Step-5: Press CTRL + SHIFT + = and here you go:

insert multiple rows in excel using name box 2

    6. Copy and Paste

Microsoft Excel is a ridiculously user-friendly and amazing program to work with. Can you believe that you can use a simple copy-paste method to insert multiple new rows into your dataset? Well, do the following steps to see the magic: 

      Step-1: Select as many blank rows as you want from anywhere you like to insert in.

      Step-2: Select the same number of rows within your table.

      Step-3: Right Click anywhere on the selected area.

      Step-4: Select Insert Copied Cells from the popup menu.

insert multiple rows in excel using copy and paste

Things to Remember

      1. Always go through the row selection procedure first before insertion.

      2. Use ALT + I + R or CTRL + SHIFT + = as the insertion hotkey.

      3. Use SHIFT + SPACE to select the entire row.

Conclusion

We tried to put together six different methods step by stepwise to insert multiple rows in Excel. All of the methods are super handy and easy to use. You can pick up any one of them at your convenience and practice it thoroughly. For a better understanding of each of the methods, we have included corresponding images illustrating each of the procedures. Hopefully, this article might meet all of your expectations.

 

Mrinmoy

Hi! This is Mrinmoy. I write about Excel and VBA stuff for Exceldemy. I have my graduation completed from Khulna University of Engineering & Technology, Bangladesh. I have an immense interest in Datascience and Machine Learning. I like to play guitar and watch Tedtalks in my leisure time. I used to be an indie filmmaker and a wedding photographer. I'm liberal to any kind of constructive criticism and inclined towards expanding my learnings.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo