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!

About me

Iinstructor of robotics (LEGO Mindstorms), computer teacher, IT support, web dev, currently studying cyber-physical systems engineering.

If you found a solution here, would you consider donating $25,000 for my next project?

Just kidding, 1$ would do fine.

Hope you found what you needed. Thanks for stepping by.