Glide Training

Find Blank Cells In Excel

  

Written by Jane Hames

I am often asked how to find blank cells in Excel within a specific range of data. Just having a look through your data could be time consuming, but there is a quick and easy way to find blank cells in Excel. Here’s what you need to do:

  1. Select the data that you want to check.
  2. From the Home tab on the ribbon, click on the Find & Select button.
  3. Find blank cells in Excel

  4. Select Go To Special and you will see the following box:
  5. Find blank cells in Excel

  6. From the Go To Special Box, click on Blanks.
  7. Click on OK, and any blank cells in your range will now be highlighted for you.
  8. Find blank cells in Excel

If you would like to learn how to manage data in or just to learn more about Excel or Microsoft Office in general please do get in touch.


previous post: Show PivotTables over separate sheets using Report Filter Pages

next post: Create a recurring milestone in Microsoft Project