If you have lots of data and want to quickly find the blanks in your data, you can use the Go To Special feature in Excel.
In our example, we have a data set with a list of people and whether they’ve done certain tasks. The issue is that it’s a bit difficult to see who is falling behind at a glance.
![](https://static.wixstatic.com/media/749de7_2bf6ef05d0594c3f87d71a1784776cca~mv2.png/v1/fill/w_49,h_17,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/749de7_2bf6ef05d0594c3f87d71a1784776cca~mv2.png)
To highlight the blanks, click into your data set and click on the Find & Select box from the Home Tab. Then select the Go To Special option.
![](https://static.wixstatic.com/media/749de7_e665b4e2b6d845a7bc456109fa657684~mv2.png/v1/fill/w_49,h_13,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/749de7_e665b4e2b6d845a7bc456109fa657684~mv2.png)
In the dialogue box that comes up, select the Blanks option.
![](https://static.wixstatic.com/media/749de7_7f5b07fad4594203b67c0eada103fead~mv2.png/v1/fill/w_95,h_108,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/749de7_7f5b07fad4594203b67c0eada103fead~mv2.png)
This will then highlight all the blanks in the data set.
![](https://static.wixstatic.com/media/749de7_c040f70cc0d64dcfbfd52d8979a8e285~mv2.png/v1/fill/w_49,h_17,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/749de7_c040f70cc0d64dcfbfd52d8979a8e285~mv2.png)
With these cells selected, you can highlight the cells a certain color to make it more visually easy to spot the blanks. You can also type something and hit Ctrl + Enter and all the selected cells will be filled with what you typed.