Let’s see how to fill the blank cells in a sheet with 0 in excel.
We often come across a situation where we have to fill the blanks with 0 or with any value that serves our purpose.
We will see an easy example as to how to fill the blank cell with 0 in excel.
Below is the sample data in which we want to fill blank with 0.
Select the data part in the table and press keyboard shortcut Ctrl+G to open the Go to option in excel.
Click on “Special” option at the bottom left corner and select the blank, press OK.
It will show you all the cells in your selection with blank.
Now press F2, enter “0” and press Ctrl+Enter to populate all the blank cells with 0.
Hope this helped.