Shortcut recipe: remove specific rows

This worksheet contains measurement data.

Here’s a nice workaround, when you have this problem.

It’s actually useful shortcut recipe itself.

This gets you near the bottom of the data.

Now, move right and extend the selection up.

Ok, so now I have a count of all non-blank cells.

Now, I could filter the list for zero values, and then delete.

But I can also use Go To Special.

For that, I’ll just use the IF function.

Now the formula returns TRUE only when all cells in all columns are blank.

I can use Go To Special again, this time selecting formulas that return logicals.

Finally, with all TRUE values selected, I can delete entire rows as before.

Using the same basic recipe, you’re able to remove rows that meet almost any condition.