Click Run button.Ħ# type rows number that you want to insert, then click OK button. Then clicking “ Save” button.Īnswer = InputBox('How many Rows to insert? (50 Rows maximum)')ĥ# back to the current worksheet, then run the above excel macro.

If you want to insert multiple rows with VBA macro in Excel, you can follow the below steps:ġ# click on “ Visual Basic” command under DEVELOPER Tab.Ģ# then the “ Visual Basic Editor” window will appear.ģ# click “ Insert” ->” Module” to create a new moduleĤ# paste the below VBA code into the code window. Method 4: Insert multiple rows in Excel using Excel VBA macro Then right-click on it, choose Insert Copied Cells option from the drop-down menu list.Ĥ# you will see that multiple rows are inserted after row 2.Īnd if you need to insert multiple columns using Insert Copied Cells method, just select multiple columns in the above Step1. Insert Multiple Rows and Columns is a powerful and easy-to-use Microsoft Excel Add-In for inserting multiple blank rows and columns between each row and. You can also use the Insert Copied Cells functionality to inert multiple rows or columns, just follow the below steps:ġ# select multiple rows in your worksheet (the selected rows should be equal to the number of rows that you want to inert)Ģ# press Ctrl +C to copy the selected rowsģ# select the destination rows, such as, if you want to insert new rows between Row2 and Row 3, then you should select Row 3. Method 3: Insert multiple rows or columns in Excel using Insert Copied Cells feature

How to add multiple rows in excel 2013