Forum Discussion
Delete Empty Rows ONLY
Thanks guys for your comments. I found a much better, cleaner and faster solution using a macro on another post.
Located here:
Deleting blank rows in excel..... but not deleting partially blank rows | Microsoft Community Hub
The accepted answer is not the good solution. Scroll to find the comment with the attached macro by Lorenzo Kim. I used the option to "Delete row if entire row is blank", and made it a button on the Formulas tab, so 1 click and it's done.
Thanks guys for your comments. I found a much better, cleaner and faster solution using a macro on another post.
Located here:
Deleting blank rows in excel..... but not deleting partially blank rows | Microsoft Community Hub
The accepted answer is not the good solution. Scroll to find the comment with the attached macro by Lorenzo Kim. I used the option to "Delete row if entire row is blank", and made it a button on the Formulas tab, so 1 click and it's done.