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 wh...
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.