The easiest way to replace blank cells with zeros in Excel is to use the Go To Special function.
The following example shows how to use this function in practice.
Example: Replace Blank Cells with Zero in Excel
Suppose we have the following dataset that shows the points scored by various basketball teams:
Suppose we would like to replace the blank cells in the Points column with zeros.
To do so, type Ctrl+G to bring up the Go To window:
Then click the Special button in the bottom left corner of the Go To window.
In the new window that appears, select Blanks and then click OK:
All of the blank values in the Points column will automatically be highlighted:
Lastly, type in the value 0 in the formula bar and press Ctrl+Enter.
Each of the blank cells in the Points column will automatically be replaced with zeros.
Note: It’s important that you press Ctrl+Enter after typing the zero so that every blank cell will be filled in with a zero instead of just the first blank cell selected.
The following tutorials explain how to perform other common tasks in Excel:
How to Replace #N/A Values in Excel
How to Interpolate Missing Values in Excel
How to Count Duplicates in Excel