PlayInfoBox

Home /Utilities /How to Remove Blank Rows in Excel at Once

How to Remove Blank Rows in Excel at Once

Tap each step to follow along in order.

  1. Select the data range

    Select the data range that has blank rows mixed into it.

  2. Open "Go To Special"

    Click "Home > Find & Select > Go To Special."

  3. Select "Blanks"

    In the Go To Special dialog, choose "Blanks" and click OK to select every blank cell.

  4. Delete the selected rows

    Right-click one of the selected cells and choose "Delete > Entire Row."

  5. Why it matters

    Instead of hunting down and deleting blank rows scattered irregularly through a data set one by one, a few clicks clear them all at once, leaving you with clean data.

When blank rows are scattered through your data

Even when blank rows are spread irregularly through a data set, Go To Special skips the manual hunt entirely and lets you clean everything up in just a few clicks.

Back up before deleting

Because a bulk delete like this is hard to undo cleanly, it is worth making a copy of the sheet first, or at least visually confirming which blank cells got selected before deleting. The same technique also works well on a filtered result, not just a full data range.

Frequently Asked Questions

Will rows with only some blank cells also get deleted?

Only cells that are completely blank within the selected range are affected, so select the range carefully to avoid deleting a row you did not intend to.

Can I preview what will be deleted first?

Yes β€” selecting Blanks through Go To Special highlights every blank cell on screen, so you can check exactly what is selected before deleting.