How to quickly remove rows that have empty values

Let’s take a look.

Here’s our big list.

We want to remove all of the rows that don’t have a Last login date.

We could just work our way through the list, deleting those empty rows one by one.

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

To start off, pick the entire “Last login” column.

Then check that you are on the Home tab of the ribbon.

Now click Find & Select and choose Go To Special.

Select “Blanks” and click OK. Excel has now selected all of the blank cells in the column.

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 where all of the rows contain a value for Last login.

We hope this tip is useful to you.

Otherwise, you could accidentally delete it.

We’ll see you next time.