Quickly Insert Multiple Rows or Columns in Excel

This post will guide you how to quickly insert multiple rows or columns in your Microsoft worksheet. You will see that how to add new multiple rows or columns with shortcut or insert feature, or insert copied cells in excel. Or how to quickly insert rows or columns with Excel VBA macro.

Suppose that you want to quickly insert 5 blank rows between row 4 and row5 in your worksheet, and how to do it? May be you can do it by manually, but this is not a good idea, because if you need to insert hundreds of blank rows or columns, it will be tedious and time-consuming.

Of course, there are several ways to quickly insert new multiple rows or column in Excel. Let’s see the below detailed description.

Method 1: Insert multiple rows or columns in Excel using Insert feature

Insert Rows:

If you want to insert 5 rows between Row 3 and Row 4 in your worksheet, then you can do it following steps:

1# you should locate the destination row, it should be Row 4, so select 5 entire rows below from Row 3 using the row number buttons.

insert multiple rows or columns 1

2# On the HOME tab, click Insert command under Cells group. Or click Insert Cells from the drop-down list of Insert.

insert multiple rows or columns2

Or you can right-click on the selected rows, then choose the insert option from the pop-up menu list.

insert multiple rows or columns3

You will see that 5 rows are inserted after Row 3 in your worksheet.

Insert Columns:

If you want to insert 5 columns between column B and column C using insert feature, just do it follow:

1# select 5 columns next to column C (includes the column 3) using the column number buttons.

2# On the HOME tab, click Insert command under Cells group. Or click Insert Cells from the drop-down list of Insert.

insert multiple rows or columns5insert multiple rows or columns6

Method 2: Insert multiple rows or columns in Excel using shortcut

You can also use the shortcut F4 to insert multiple rows or columns in Excel, and this is the simplest way to insert new rows or columns in Excel.

Insert Rows:

If you want to insert 5 rows between Row 2 and Row 3, then you just need to select the Row 3, then press F4 shortcut 5 times, then it will insert 5 rows after Row 2.

Insert Columns:

If you want to insert 5 columns between Column B and Column C, then you just need to select the entire Column C, then press F4 shortcut 5 times. You will see that 5 new columns are inserted in your worksheet.

Method 3: Insert multiple rows or columns in Excel using Insert Copied Cells feature

You can also use the Insert Copied Cells functionality to inert multiple rows or columns, just follow the below steps:

1# select multiple rows in your worksheet (the selected rows should be equal to the number of rows that you want to inert)

2# press Ctrl +C to copy the selected rows

insert multiple rows or columns7

3# select the destination rows, such as, if you want to insert new rows between Row2 and Row 3, then you should select Row 3. Then right-click on it, choose Insert Copied Cells option from the drop-down menu list.

insert multiple rows or columns8

4# you will see that multiple rows are inserted after row 2.

insert multiple rows or columns9

And if you need to insert multiple columns using Insert Copied Cells method, just select multiple columns in the above Step1. Then repeat the rest steps.

Method 4: Insert multiple rows in Excel using Excel VBA macro

If you want to insert multiple rows with VBA macro in Excel, you can follow the below steps:

1# click on “Visual Basic” command under DEVELOPER Tab.

Get the position of the nth using excel vba1

2# then the “Visual Basic Editor” window will appear.

3# click “Insert” ->”Module” to create a new module

convert column number to letter3

4# paste the below VBA code into the code window. Then clicking “Save” button.

insert multiple rows or columns10

Sub InsertRowsAtCursor()
    Answer = InputBox("How many Rows to insert? (50 Rows maximum)")
    NumLines = Int(Val(Answer))
    If NumLines > 50 Then
        NumLines = 50
    End If
    If NumLines = 0 Then
        GoTo EndInsertLines
    End If
    Do
        Selection.EntireRow.Insert
        Count = Count + 1
    Loop While Count < NumLines
    EndInsertLines:
End Sub

5# back to the current worksheet, then run the above excel macro. Click Run button.

insert multiple rows or columns11

6# type rows number that you want to insert, then click OK button.

insert multiple rows or columns12

insert multiple rows or columns13

 

Related Posts

Find and Replace Multiple Values

This post will guide you how to find and replace multiple values at once with VBA macro or using formula  in Excel. How do I make multiple find and replace in Excel. Suppose that you have a few cells containing ...

VBA Macro For VLOOKUP From Another Sheet

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you how to use VBA code to vlookup data ...

How To Insert Comments in Protected Worksheet in Excel

This post will show you how to allow comments in a protected worksheet in Excel. You can easily to insert comments into cells in a normal worksheet in Excel, but if want to insert a comment in a worksheet that ...

How To Convert Text to Upper Cases(Using VBA) in Excel

This post will show you how to switch from lower case to upper case in Excel. and I am going to show you two different ways of converting text to upper cases using formula or VBA macro in Excel 2013,Excel ...

How To Hide Every Other Row in Excel (Using VBA)

This post will show you how to hide alternate rows or columns in Excel or how to hide every third, fourth, fifth row or column in Excel. If you want to hide every other row in your current worksheet, how ...

Comments

So empty here ... leave a comment!

Leave a Reply

Sidebar