Find blank cells in a range

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

  1. Select the range of cells where you want to search.

  2. On the Edit menu, click Go To.

  3. Click Special.

  4. Select Blanks, and then click OK.

    The blank cells in the range are selected.

See also

Filter a list of data

Ways to count cells in a range of data

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.