Forum Discussion
Delete Empty Rows Quick?
I have a worksheet with thousands of rows and a blank row between each row with data. Is there a way to remove all those blank rows quickly? I need to sort by a column and I can't right now. I ass...
A simple VBA solution that does exactly what you want...at least I think so 🙂.
Here’s a approach that:
- Deletes only rows that are completely empty across all columns.
- Leaves any row with at least one non-empty cell untouched.
- Works in Excel 2016 and Excel 365.
The code is in the attached file and can be tested immediately.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.