ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software

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

Updated on January 8, 2013

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.


    0 of 8192 characters used
    Post Comment

    • Taleb80 profile image

      Taleb AlDris 7 years ago


      Thank you for stopping by.

    • jacobkuttyta profile image

      jacobkuttyta 7 years ago from Delhi, India

      Very helpful