Delete Blank Rows in Excel: all of them at once

Exported data comes with empty rows scattered through it. Deleting them one by one is slow. Two methods remove all of them at once.

Method 1: Go To Special (rows that are completely empty)

1. Select one column that has a value in every real row — usually the first column (click its letter).
2. Press F5 › Special › tick Blanks › OK. Every empty cell in that column is selected.
3. Right-click any selected cell › Delete › Entire row.

Method 2: Filter (rows empty in one column)

1. Click inside the data, press Ctrl + Shift + L.
2. Click the arrow on the column, untick Select All, tick only (Blanks). OK.
3. Select the visible row numbers, right-click › Delete Row.
4. Press Ctrl + Shift + L to clear the filter.

Check it worked

Press Ctrl + Down from the top of the column. It should jump straight to the last row with no stops in between.

The mistake that deletes real data

In Method 1, selecting the whole sheet before F5 › Blanks selects every empty cell — including cells in rows that have data elsewhere. Delete › Entire row then removes those rows too. Always select a single column that is never empty in a real row.

Rows that look blank but are not

A single space in a cell is not blank. Run Find and Replace (Ctrl + H): Find what: one space, Replace with: nothing, Replace All. Then try again.