Learn the criteria expression for finding blank cells using Excel's Advanced Filter feature. A few weeks ago, I showed you how to use And and Or operators with Excel’s Advanced Filter feature.

If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" feature. Here's how.