Preparing Reports in Excel - How to Delete/ Remove Empty Lines fast?

As an accountant you always need to prepare many reports in MS excel, for example when you extract a report from Oracle (ERP), most of the accounting reports will be generated with some extra empty lines, and you need to delete these empty rows to have this reports ready to submit to your management.

The easiest way for this can be done following these steps:

1- Select the first column of your report by clicking Ctrl + Space .

2- Press F5 to get (Go To window) and click on (Special) bottom or (Alt + S) then choose Blanks (K).

3- The blank cells in this column will be highlighted.

4- Then right click any highlighted cell and click D (Delete…)

5- Choose entire row (R)

6- Although in every row there is just one cell highlighted, the row will be deleted.
A- Take care when deleting rows that they are empty, so you don’t waste data.
B- You can hold control bottom & select one cell in every row and then follow the 4th & 5th steps the get the needed line deleted.

If you have an quetion about using Microsoft Excel, type it in the comments, I hope I'll help.

More by this Author

Comments 2 comments

jacobkuttyta profile image

jacobkuttyta 6 years ago from Delhi, India

Very helpful


Taleb80 profile image

Taleb80 6 years ago Author


Thank you for stopping by.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.

    Click to Rate This Article