Quickest way to Select and Delete empty Rows

Data dumps from 3^rd party systems often give us data with a plethora (lots of) blank rows. Finding and Deleting these Rows can take an age. Not any more though! This cool tip will show you how to use the Go To Special… Blanks feature to detect and delete all these unwanted rows in a flash!

To become more proficient with using data, check out one of our online Excel courses, with training offered for both beginners to advanced users.