You could delete the rows one by one, but that will take a long time if you have a big list.

In todays ExcelJet tip, well show you a cool way to delete rows that are missing values in one step, even when your list contains hundreds or thousands of rows.

We want to remove all of the rows that dont have a last login date.

The problem is, this is a really big list, with over 11,000 rows, and deleting the rows manually will take way too long.

Excel has now selected all of the blank cells in the column.

Now we have a clean list where all rows contain a value for Last login.

If we hop down to the bottom of the list, there are a little more than 8,000 rows, which means we just deleted almost 3000 rows with no value for Last login.

Before you try it, make sure you dont have important information above or below the list youre working with.

We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

I now need to work these arrays into my complicated spreadsheets -Jeremy.

Got a different version No problem, you can still follow the exact same steps.

You have better things to do than scroll through hundreds of rows right-clicking and deleting.

It had a single blank cell, but the entire row has been removed.

Once youve done it a few times, it gets much fasterI recommend learning it to reduce the risk of losing important cells.

One last step: just let us know where should we should send it.

Remove Blank Rows In Excel For Mac