Quickly Fill Blank Cells in Excel with 0 - Excel Trick

Quickly fill the blank cells of an Excel table. Blanks cells can cause messy data and complications in some tasks of Excel.

To get around this issue, you can fill blanks with a value. In this video tutorial, we fill the blank cells with a 0.

This is done quickly and with no formulas. We select the range we want Excel to target. It then selects all of the blanks and pastes in a 0.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[globalschoolofeconomics]

Superb presentation in terms of both pace and content. Excellent work. Well done.

[KartikDeepakShah]

That is such a brilliant explanation. Thank you so much

[XIhoshIX]

you're awesome! saved me so much time!!

[shovondhaka]

Thanks you to showing us that easiest way to do that

[gauravsharma-gmpu]

Best 👍 vedios explained in simple way .

[steve-o]

Thank You. Very Helpful Information! Cheers!

[simranthiara]

I keep getting the "This can't be done on a multiple range selection" when trying to paste :(

[quicklines]

How to get back to the original table without control z

[fahadafzal]

message pooping up when i click data validation saying "No cells were found"

[middlemane]

They don't have this option in Office What do I do??

[lalmuansangakhawlhring]

Thank you so much sir.. I am glad you make this vid.. you just save me from my professors wrath.. thank you

[mweibleii]

Wow - such an awsome time saver. This may be the very first time in 25 plus years that I can say, I don't mind MS Office :)