In this tutorial, you will learn about ‘How to Insert Blank Rows’ after every 2nd or 3rd or even after every nth row of the dataset.
Here we are going to use the below-given dataset to insert the blank rows.
See the dataset image below:-
Insert Blank Rows After Every Next Rows
To insert a blank row after every next row of the dataset, we will use the following procedure.
First, we will insert a temporary ‘Helper Column’ before the very first column of the dataset.
After solving the problem, we will delete this temporary ‘Helper Column’ because of no use.
To inserting a ‘Helper Column’ before the very first column, we need to click on ‘Column A’.
‘Column A’ is selected now.
Press ‘Right-Click’ from the mouse on any part of the selected column to insert a new blank column.
Click on ‘Insert’, and see that one column is inserted before ‘Month’ (Column A).
Name this column as ‘Helper Column’.
Then start dragging numbers into this column from 1 to the last row of the dataset.
See the image below:-
Here we have our dataset till the 13th of the row, so we will drag it till the 13th row.
Then again start dragging numbers from the next row after the dataset in the same column.
This time we will drag at least one more number from the above-dragged number.
See the image below:-
The next step is to select all the datasets including ‘Helper Column’ till the last dragged numbers (13).
Now we will short this whole dataset in order to smallest to largest number format.
We have two different methods to sort the dataset.
Method1:- Using the “Data” tab From the Ribbon
Method2:- Go to the “Home” tab Then “Editing” Group (extreme right in the ribbon) and find ‘Sort & Filter’ Then Use the ‘Custom Sort’ option
Using both ways will get the same result.
Here we will use the first method by using the “Data” tab from the ribbon.
Click on the “Data” tab in the ribbon
See the image below:-
Putting the following values in the appropriate field
Column Sort by: – Helper Column
Sort On: – Values
Order: – Smallest to Largest
See the image below:-
Then press “OK”.
After pressing the ‘OK’ button see the result below:-
See the blank rows are inserted after every row in the given dataset
Now there is no need to keep the ‘Helper Column’ here.
To delete this by selecting this whole single column and use ‘Right-Click’ properties from the mouse and click on the “Delete’ option
See how the dataset looks after deleting the helper column.
See the image below:-
Once the ‘Helper Column’ is deleted, see that there is a blank row has been inserted after every row in the dataset.
Insert Blank Rows after Every 2nd or 3rd or nth Row
Again insert a ‘Helper Column’ and drag the number from 1 to the last row of the dataset.
Then start dragging numbers from the next line, in the 2, 4, 6, format and drag it at least one more number from the above-dragged list.
See the image below:-
Select all the datasets, including ‘Helper Column’, and till the last row of the dragged number.
Then again Go to the “Data” tab and sort the data as we did in a previous way.
Once we did this, press ‘OK’.
See the image below:-
Again delete the temporary inserted ‘Helper Column’.
See what how our new dataset looks like.
A blank row has been inserted after every 2nd row in the dataset.
In the same way, we can insert a blank row after every 3rd row in the dataset and so on.
Now the same way, we can insert a blank row after every 3rd or 4th, or even nth row in the dataset.
If you want to learn more about this, please visit Microsoft Office Support.
I hope that you find this tutorial helpful.
Please free to put your comments or suggestion in the comment box below.
Thanks
Narendra
Related Post
5 Ways to Delete Blank Rows in Excel (With VBA Macro)
How to Change the Background Colors in Excel VBA
How to Wrap Text in Excel – 4 Easiest Method