How to quickly remove blank rows

Even better, Excel does all the hard work for you.

Let’s take a look.

Here we have a really big list that contains a lot of empty rows.

Sure, we could just work our way through the list, deleting these empty rows one by one.

But that will take a really long time, and it won’t be any fun at all.

So let’s look at a really fast way to do it using Excel’s Go To Special command.

To start off, opt for entire first column.

Then ensure you are on the Home tab of the ribbon.

Now click Find & Select and choose Go To Special.

Now carefully right-mouse hit one of the empty cells, and choose Delete from the menu.

Then select Entire row, and smack the OK button.

Now we have a clean list with no blank lines.

See you next time.