Excel - MIS Reporting



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]


64512 Views 2 Likes Comment   Share Students   Report


About the Author

Trainer

/coaching/excel.asp

Comments :

Related Articles


Loading


Popular Articles





CCI Pro

CCI Articles

submit article


Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details