There, select PlaceRows in the Macro name and press Run.

After that, close the Visual Basic window and select Macros under the Developer tab.

Then, select Module under the Insert tab.

Next, select the Visual Basic feature under the Developer tab.

In the beginning, select the range of cells you want to work with.

Finally, just Delete the Blank Column and you’ll get your desired output.Īnother process to add rows after every other row is with VBA code.

After that, you’ll see that your dataset is being rearranged among itself.

There, select Sort Smallest to Largest from the Sort options.Now, select the range of cells except the header.Again, fill up the column serially like it’s shown in the image below.Next, fill up the Column serially till the end of the data just like the following picture.Next, right-click on the mouse and select the Insert option from the list.First of all, select the left-most column.Here, we’ll make use of Blank Column and Sort feature to Insert a row after every other row. 2.1 Excel Blank Column and Sort Feature to Insert Row This method will add a Row after Every Other Row in Excel. Read More: How to Insert Row in Excel ( 5 Methods)Ģ. Finally, it’ll add a row below the selected cell.There, select the Macro name ‘ PlaceRowBelow’.Then, select Macros under the Developer tab.After that, close the Visual Basic window.There, copy the Code given below and paste it into the Module window.Next, select Module under the Insert tab.First, select the Visual Basic feature under Developer the tab.In this method, we’ll use VBA to Insert a Row Below. We can easily add a row under the selected cell in Excel using VBA code. 5 Effective Methods in Excel to Insert Row Below 1.

Excel shortcut keys insert row