How to Remove Blank Rows in Excel

The safest way to remove blank rows in Excel is filtering them out and deleting the visible rows, or using Go To Special to select every blank cell at once and delete their rows — not sorting, which can silently scramble a table if the whole row range isn't selected first.

How do I remove blank rows using Go To Special?

Go To Special selects every blank cell in a range in one operation, and deleting entire rows from that selection removes every blank row at once without deleting rows that only have some blank cells.

1. Select the full data range (e.g. A1:D200)
2. Press Ctrl+G (or F5) → click "Special..."
3. Choose "Blanks" → OK
4. Right-click any selected cell → Delete → Entire Row

Warning: this selects blank CELLS, not blank ROWS.
If a row has data in column A but a blank in column C,
that row's C cell gets selected too — deleting entire
rows from that selection would delete a row that isn't
fully blank. Only use this method on a single column
that reliably indicates a truly blank row (see below).

To make this safe on a multi-column table, first build a helper column that's blank only when the entire row is blank — for example =COUNTA(A2:D2) — then run Go To Special → Blanks on that helper column alone, not the whole table.

How do I remove blank rows by filtering?

Filter the helper column (or any column that's reliably populated) to show only blanks, select the visible rows, and delete them — filtering guarantees you only ever see and delete fully blank rows.

1. Add a helper column: =COUNTA(A2:D2)
   (0 means every cell in that row is blank)
2. Select the table → Data → Filter
3. Filter the helper column to show only 0
4. Select the visible row numbers (not Ctrl+A —
   right-click a row number, then Select All)
5. Right-click → Delete Row
6. Remove the filter and delete the helper column

This is the most reliable manual method because you visually confirm exactly which rows are being deleted before you delete them.

How do I remove blank rows with Power Query?

Power Query has a built-in step that removes fully blank rows and, unlike a manual delete, re-applies itself automatically every time you refresh the query against updated source data.

1. Select your data → Data tab → From Table/Range
2. In the Power Query Editor: Home → Remove Rows
3. Click "Remove Blank Rows"
4. Home → Close & Load

This removes rows where every column is blank.
Refreshing the query re-runs this step automatically,
so newly imported blank rows get removed too —
no re-doing the cleanup by hand each time.

See Power Query basics if you haven't used the Query Editor before — blank-row removal is one of the simplest transformation steps to start with.

Why is sorting to remove blank rows risky?

Sorting to push blanks to the bottom only works safely when the entire table — every column — is included in the sort selection; select just one column, and Excel can sort that column independently of the rest of the row, permanently mismatching data across columns with no easy way to detect it happened.

Risk scenario:
1. You click a single column, then Data → Sort A to Z
2. Excel prompts "Expand the selection?" — if you
   choose "Continue with the current selection," only
   that column sorts; every other column stays in place
3. Result: row 5's Name is now next to row 12's Amount
   — data is silently cross-matched wrong, and it looks
   completely normal until someone notices totals are off

Safe sorting for blank-row removal:
1. Convert the range to an Excel Table first (Ctrl+T)
   — Tables always sort whole rows together, never a
   single column in isolation
2. Sort by any column with reliably blank cells on
   blank rows
3. Blank rows collect at the bottom → delete them
4. Convert back to a range if needed

Using an Excel Table before sorting removes this risk entirely, because Tables always keep every column's row alignment intact during a sort — a plain range does not offer that guarantee if only part of it is selected.

Which method should I use?

Situation	Best method
One-off cleanup, single column of data	Go To Special → Blanks
One-off cleanup, multi-column table	Helper column + filter
Recurring import that needs the same cleanup every time	Power Query
Sorting to group blanks	Only on an Excel Table, never a partial column selection

What are common mistakes when removing blank rows?

• Deleting entire rows from a Go To Special → Blanks selection on a multi-column table: this deletes rows with any blank cell, not just fully blank rows
• Sorting a single column without expanding the selection: permanently misaligns every other column
• Not removing the helper column after filtering: leaves a stray COUNTA column in the final data
• Deleting rows instead of clearing contents inside a Table: Table rows should be deleted with Table-aware commands so the structured range resizes correctly