Lesson#153: How to insert blank rows after every row in sheet, No Formula method

Lesson#153: How to insert blank rows after every row in sheet, No Formula method

Hello buddies! In this post, I am going to share a unique trick about how to insert blank rows after every row in the sheet. Definitely no formula, no functions needed for this. It’s so easy that I will use some cleverness to do this.

Suppose this is an example of the small database in your excel sheet. Here you are having many rows. But you need to insert 3 or 4 or 5 blank rows after every row. Should you use VBA, special formula? No, you don’t need it.

I am going to add another column beside and put manual numbering (Without any formula) up to the bottom row.

Now I will copy this numbering below this column. Here is the thing to remember if I need to insert 3 rows then I will copy them 3 times.

Now I have applied Sort & Filter on the header.

How to insert blank rows

And then click on the I column filter and click on Sort Smallest to Largest.

How to insert blank rows

And just see the magic. No formula is needed to do this.

How to insert blank rows

Now you can delete the extra column, I.

Subscribe to the channel Excelabcd to get more Excel videos.

See also  Lesson#44: A Simple trick to paste in reverse order

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

0 Comments on “Lesson#153: How to insert blank rows after every row in sheet, No Formula method

Leave a Reply

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

*