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](https://excelabcd.co.in/wp-content/uploads/2022/06/153-THUMB.png)
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.
![](https://excelabcd.co.in/wp-content/uploads/2022/06/153-1.png)
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.
![](https://excelabcd.co.in/wp-content/uploads/2022/06/153-2.png)
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.
![](https://excelabcd.co.in/wp-content/uploads/2022/06/153-3.png)
Now I have applied Sort & Filter on the header.
![How to insert blank rows](https://excelabcd.co.in/wp-content/uploads/2022/06/153-4.png)
And then click on the I column filter and click on Sort Smallest to Largest.
![How to insert blank rows](https://excelabcd.co.in/wp-content/uploads/2022/06/153-5.png)
And just see the magic. No formula is needed to do this.
![How to insert blank rows](https://excelabcd.co.in/wp-content/uploads/2022/06/153-6.png)
Now you can delete the extra column, I.
Subscribe to the channel Excelabcd to get more Excel videos.
0 Comments on “Lesson#153: How to insert blank rows after every row in sheet, No Formula method”