Solved: Fill blanks with zeroes in Excel

excel blanks to zeroesNeed 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!

Post Author: Tom Pai