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.
Pick where you want to insert the multiple rows. Then hold CTRL+SHIFT and press the + key.
This will result in a single blank row being inserted below it.
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.
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?
Select a number of blank rows. In this example I highlight two rows. Then right click anywhere within the selected range and select “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.
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.
This will most likely result in a dialogue prompt that allows you to select “shift cells down.”
Then the blank cells will be inserted and the cells below will be shifted down.
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.
Do you have an easier or quicker method? If so we would love to hear it, comment below!