To find blank cells using an Advanced Filter, use a single equal sign as your criteria expression. Let’s look at a quick example using the same setup from a few weeks ago.

This month, Susan Harkins introduces an Excel user to advanced filtering and helps a PowerPoint user reduce his work when positioning pictures in PowerPoint.