Excel for mac find blank cells

broken image
broken image
broken image

Of course, you can fill them manually or copy and paste one by one, but this is not a good choice for filling large blank cells. Supposing you have a large worksheet which is populated with hundreds of blank cells, and now you would like to fill the blank cells with a specific value you like, such as the number of 0. How to fill blank cells with 0 or other specific value in Excel?