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
It is a good chance to read others' culture by simply reading some of their thinker' quotes.
Many people make mistakes when Calculating Weighted Average Cost of Inventory, so here we try to make the issue simpler using Microsoft Office Excel, I hope it will help you.
Here, I describe how to calculate standard deviation manually & by using Microsoft Office Excel. More, I speak about the benefits of using this formula in business life & how to use it.