Tally

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
[/articles/article_display_list_by_member.asp?member_id=997936]

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:
[www.caclubindia.com/coaching/excel.asp]


Tags :



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



Comments


update