Solved: Fill blanks with zeroes in Excel
Need to fill blanks with zeroes in Excel? No worries, here is the simplest solution.
1. Select your area to be affected
2. Go to Find & Select -> Go To Special -> Blanks
3. Type in 0 and press Ctrl + Enter
4. See the magic happen!