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 CAClubindia.com, click here

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

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

Tags :

Category Students, Other Articles by - CA Rishabh Pugalia (ExcelNext)