How to Remove Blank Rows in Excel the Easy Way

Blank rows in Excel can mess up your data analysis, printing, and sorting. Whether you’re cleaning up a spreadsheet or prepping it for a report, removing empty rows shouldn’t take forever. Here’s the fastest and easiest way to get it done.

Method 1: Use Excel’s Filter Tool

If the blank rows are scattered throughout your data, the filter tool is your best friend.

Steps:

1. Select your entire dataset.
2. Go to the Data tab and click Filter.
3. Use the dropdown on a column that has blank cells in the blank rows.
4. Uncheck everything except Blanks.
5. Select all the visible blank rows, right-click, and click Delete Row.
6. Go back to the dropdown and choose Select All to restore your data view.

Done. All blank rows are gone.

Method 2: Use Go To Special

This one’s quicker if your entire blank rows are truly empty—no spaces, no hidden characters.

Steps:

1. Select your data (or the entire worksheet with Ctrl + A).
2. Press F5 (or Ctrl + G) to open Go To.
3. Click Special → select Blanks → click OK.
4. Right-click any of the selected blank cells and choose Delete → then Entire Row.

Poof. Empty rows deleted in seconds.

Method 3: Use a Simple VBA Script (Advanced Users)

If this is something you need to do often, a quick VBA macro can save time.

Sub DeleteBlankRows()
    Dim Rng As Range
    Dim RowCount As Long
    Dim i As Long

    Set Rng = ActiveSheet.UsedRange
    RowCount = Rng.Rows.Count

    For i = RowCount To 1 Step -1
        If WorksheetFunction.CountA(Rng.Rows(i)) = 0 Then
            Rng.Rows(i).EntireRow.Delete
        End If
    Next i
End Sub

How to use:

• Press Alt + F11 to open the VBA editor.
• Insert a new module and paste the code.
• Run it.

It goes through your worksheet and deletes any completely empty rows.

Final Tip: Check for “Invisible” Content

Sometimes a row looks empty but isn’t—there might be a stray space or invisible character. If your blank rows aren’t deleting, try using TRIM() or clean up with Find & Replace (find spacebar characters and replace with nothing).

Conclusion

Don’t let blank rows slow you down. Whether you prefer using filters, built-in tools, or automation with VBA, Excel makes it easy to clean up your data. Choose the method that fits your workflow and move on to the important stuff.