Forum Discussion
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 what I want it to resemble. The bottom several green blank rows are what I want to batch Delete.
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.
3 Replies
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.I posted extensive instructions with screenshots in Delete Empty Rows Quick? | Microsoft Community Hub
Here are a way to do it in Excel for Web:
Formula Helper Column
- Insert a new column at the end of your table.
- In row 2 (assuming row 1 is headers), enter this formula:
- =COUNTA(A2:Z2)
(adjust A2:Z2 to cover all your columns)
- Copy/fill down the formula.
- It returns 0 if the entire row is blank.
- Returns a positive number if there’s any content.
- Filter this helper column to show only 0.
- Delete those rows.
- Remove the helper column.
Since you mentioned you’re using Excel for Web, the helper column method is the most reliable.
My answers are voluntary and without guarantee!
Hope this will help you.
