Shortcut recipe: delete blank rows

In this first example, we have a big set of data that contains a lot of blank rows.

To quickly remove these blank rows, I can use Go To Special.

First, pick a column that should always contain data.

In this case, Column A should always have a name.

Then go for the column, and use Ctrl + G for Go To.

Then Special, then select Blanks.

At this point, every blank cell in column A is selected.

Now use Control minus to delete, and choose Entire row.

When I click OK, all blank rows are completely removed.