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.