How to Insert Multiple Rows in Microsoft Excel

Insert Multiple Rows in Microsoft Excel

Whether you are comparing PPC data, keyword ranking reports, or importing CSV lists to email marketing platforms; Microsoft Excel is still a crucial tool. I personally use it every day. A common task I always need to perform is inserting multiple rows in Excel (if you use Excel frequently you will understand why this is important)… Below are a couple ways to insert multiple blank rows quickly. The tutorials below assume you are on a PC, however most of them probably apply to the MAC version as well.

Method 1

Pick where you want to insert the multiple rows. Then hold CTRL+SHIFT and press the + key.

Method 1 - Excel

This will result in a single blank row being inserted below it.

Method 1 - Excel Blank Row

Now you can keep pressing the + symbol or hold it down and it will keep inserting blank rows. The below picture is after pressing the + key 5 times. This results 6 blank rows.

Excel Insert Blank Rows

You can then select all of those blank 6 rows and repeat the process, but now it will be inserting 6 blank rows at a time for every + key press. Make sense?

Method 2

Select a number of blank rows. In this example I highlight two rows. Then right click anywhere within the selected range and select “Insert.”

Excel Insert

This will result in the same number of rows you originally selected being copied below. So 2 copied rows becomes 4 insert. You could then easily select the 4 rows, repeat the process and then you would have 8 blank rows.

8 blank rows

Method 3

You can also copy the number of row(s) you want by selecting them with CTRL + C and or right click and select copy. Then right click and select “Insert Copied Cells…” in the area you need to expand.

insert copied cells

This will most likely result in a dialogue prompt that allows you to select “shift cells down.”

shift cells down

Then the blank cells will be inserted and the cells below will be shifted down.

blank cells

Working with Large Number of Rows

If you need to insert a large number of blank rows, or you need to be more exact then I suggest simply using method 3; copying the number of blank rows that you need from the bottom of the worksheet and then inserting them where you need them.

Better Method?

Do you have an easier or quicker method? If so we would love to hear it, comment below!

author bio
Brian Jackson

I craft actionable content and develop performance-driven WordPress plugins. Connect on Twitter or subscribe to my newsletter (once a month, no spam).

2 thoughts on “How to Insert Multiple Rows in Microsoft Excel”

  1. Excellent. Just the info I needed to insert rows in Excel on my PC. I checked several sources before finding this one, but those only applied to the MAC. Thanks!


Leave a Comment