How to insert a blank row after each data row in MS Excel ?

How to insert a blank row after each data row in MS Excel ?

So, you have MS excel sheet with many data rows and now you need to insert a new blank row after each data row.

Selecting each data row and doing insert row is not feasible unless you have all the time in the world.

Follow below steps get it done smartly.

Step 1: Open your excel file

Step 2: Add sequence number for each data row in adjacent column

Step 3: Copy all the numbers in same column below.

Step 4: Now just Sort the sequence column from lowest to highest number

Just delete the sequence column and you are done. :)

Comment and share if you like this trick. Also don't forget to subscribe for more such tips and tricks.

Never stop learning. Have a great day.