Forum Discussion

isherwoodme's avatar
isherwoodme
Copper Contributor
Sep 08, 2025

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.

 

excel
Formulas and Functions

2 Replies

Sort By
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Sep 10, 2025

    Here are a way to do it in Excel for Web:

     

    Formula Helper Column

    1. Insert a new column at the end of your table.
    2. In row 2 (assuming row 1 is headers), enter this formula:
    3. =COUNTA(A2:Z2)

    (adjust A2:Z2 to cover all your columns)

    1. Copy/fill down the formula.
      • It returns 0 if the entire row is blank.
      • Returns a positive number if there’s any content.
    2. Filter this helper column to show only 0.
    3. Delete those rows.
    4. 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.

Resources