Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Objective: To insert blank row after every line item in Excel (MIS Reporting)

Excel Technique used: “Dummy” Serial Number and SORT

Step 1: Create a new column (refer Yellow cell in Column G) and write 1 and 2

Step 2: Select both 1 and 2 and drag-down the cells jointly so that a series can be generated

Step 3: Copy the generated list and paste it once again below the original list

Step 4: Select the entire dataset

Step 5: Go to DATA tab – SORT button

Step 6: Sort the data based on the Column – “DUMMY Serial No.” –Smallest to Largest

Step 7: Delete Column G and format the table with Borders

To read CA. Rishabh Pugalia’s other articles on Excel tricks on, click here

To attend his LIVE workshop in Kolkata or Mumbai, Click here

To subscribe to CA. Rishabh Pugalia’s Online Training Program at, click here:


2 Likes   182 Shares   60501 Views


Related Articles


Popular Articles

caclubindia books caclubindia books Book

CCI Articles

submit article

Stay updated with latest Articles!