How to Insert Blank Rows after Every (2nd or 3rd or nth) Row in Excel

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 in Excel
Insert Blank Rows in Excel _ Image_01

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.

Insert Blank Rows_Image_02

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:-

 Insert Blank Rows In Excel
Insert Blank Rows_Image_03

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:-

 Insert Blank Rows In Excel
Insert Blank Rows_Image_04

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:-

  Insert Blank Rows In Excel
Insert Blank Rows_Image_05

Putting the following values in the appropriate field

Column Sort by: – Helper Column

Sort On: – Values

Order: – Smallest to Largest

See the image below:-

Insert Blank Rows In Excel
Insert Blank Rows Image_06

Then press “OK”.

After pressing the ‘OK’ button see the result below:-

    Insert Blank Rows in Excel
Insert Blank Rows Image_07

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:-

Insert Blank Rows In Excel
Insert Blank Rows Image_08

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:-

Insert Blank Rows In Excel
Insert Blank Rows Image_09

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:-

Insert Blank Rows In Excel
Insert Blank Rows Image_10

Again delete the temporary inserted ‘Helper Column’.

See what how our new dataset looks like.

Insert Blank Rows In Excel
Insert Blank Rows Image_11

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

Copy and Paste in Excel VBA: 4 Easiest Way (For Beginners)

Excel Format Painter – An Introductory Guide

Leave a Comment

Your email address will not be published. Required fields are marked *