Forum Discussion
isherwoodme
Sep 08, 2025Copper Contributor
Delete Empty Rows ONLY
I saw someone else's post, but nobody addressed the problem. Their solutions delete every row that contains a blank cell. I want to delete ONLY the rows that are COMPLETELY blank. The top rows are wh...
- Sep 14, 2025
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.
HansVogelaar
Sep 10, 2025MVP
I posted extensive instructions with screenshots in Delete Empty Rows Quick? | Microsoft Community Hub