Insert blank rows after every row in excel | Auto insert blank rows in excel

Learn How to add Blank Rows to Excel. Use the simple excel trick in order to auto insert blank rows in excel.

Steps to Insert blank rows after every row in excel

1.)Create the Sl no columns and repeat the same set of serial nos.
2.)Go to Data sort and sort the values by selecting Serial no column and select smallest to largest.
3.)Click on sort to insert the blank row after every row.
4.)Delete the serial no column once the blank row is inserted

---------------------------------------------------------------------------------------------------------
Website and Social Media Sites
-----------------------------------------------------------------------------------------------------------

[ahmedhard]

So Clever save a lot of time thanks dude

[crystal]

This is SO SMART. Me and my colleague got weirdly excited when we found this solution xD

[madhu_Svmk]

Thank you brother... Its saved lot of time

[m.sachinkumar]

Sir How to do it in Row ( Horizontal way)

[guruprasadbm]

How to insert rows after every 5 rows (5-10-15-20-25 like this)