How to Delete Blank Rows in Excel — The Right Way

How to Delete Blank Rows in Excel
— The Right Way by 

Kasper Langmann, Co-founder of Spreadsheeto

Deleting blank rows the easy way

If you have more than a handful of blank rows, deleting them manually is going to take way too much time. You have better things to do than scroll through hundreds of rows right-clicking and deleting.

So let’s look at a much faster way to do it.

Open up the first sheet in the example workbook. You’ll see that there are several blank rows in the sheet.

Also, note that row 5 isn’t completely blank—it’s just missing one value. Keep an eye on that row as we go through this procedure.

one-blank-cell

First, select the entire area you’d like to delete blank rows from. We’ll select columns A, B, and C.

columns-selected

Next, in the Home tab, click on Find & Select, and click Go To Special…

go-to-special

Select the radio button next to Blanks:

go-to-special-blanks

When you hit OK, you’ll see that only blank cells are now selected:

blanks-selected

In the Cells section of the Home tab, click Delete:

cells-delete

Clicking Delete Sheet Rows will delete entire rows, and this is often the advice you’ll find when you search “how to delete blank rows Excel” online.

But this option has a fatal flaw: it deletes rows with ANY blank cells in them.

Click Delete Sheet Rows to see what I mean.

Kasper Langmann, Co-founder of Spreadsheeto
deleted-rows-with-blanks

As you can see, the original row 5 (with the name “Albina”) is gone. It had a single blank cell, but the entire row has been removed.

That’s why this method isn’t the best. Using the next method gets better results.