Forum Discussion
Deleting blank rows in excel..... but not deleting partially blank rows
Dear Community.
It was suggested that I should share the information that helped me on the forum so that everyone can benefit from it. I totally agree. So here it is:
Suppose your last column with data is column Z.
Add this formula to AA1:
=COUNTA(A1:Z1)
Double-click the fill handle to fill down (double-check if all rows are filled with the formula, if not, copy down as far as needed).
Now turn on filter and filter the table for the value of zero in that new column.
Use goto special, blanks now and do the delete. Then remove the filter.
I also have the same question.
I am not an expert by a longshot, but I do have to manage excel reports for work so it would help me to figure this out as well.
My reports are simple and don't use functions or queries. I just need to delete the rows that have no information at all. I've been unable to find step by step instructions for this which do not remove the rows with partial information. Any assistance would be appreciated. Thanks!