Excel Tricks – Insert blank rows after every row in excel




About this tutorial:

Video duration: 00:02:52
Askmein Tutorials – This video talks about How to add Blank Rows in Excel. Use the simple excel trick in order to auto insert Blanks 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
Google+…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads