Hide Zero Values in Excel | Make Cells Blank If the Value is 0

In this video, I will show you how to hide zero values in Excel using multiple methods.
The video also covers a method to remove zero values in Excel.
There are multiple ways you can hide zero values in Excel:
-- Using an in-built functionality that hides all the zeros in the cells in the selected worksheets
-- Using conditional formatting to change the font color of the cells that have 0 in it
-- Using conditional formatting to apply a custom format that hides zero values
-- Using a custom format that specifies blank as the format for cells that have 0 in it
And in case you don't want to hide the zeroes but instead remove these, you can use Find and Replace. With Find and Replace, you can instantly find and select all the cells that have 0 in it. Once you have these selected, you can either remove these or format it or enter any specific text in it.
NOTE: When you hide a zero value in Excel, it only hides the value from being visible. It still remains a part of the cell and in case you use this cell in any calculation, the zero value will be used.
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: ruclips.net/user/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

[@davejblair]

I've been using spreadsheets for 30 years. This was the most useful 10 mins of training I have had in that whole time. Geat job!

[@trumpexcel]

Thanks for the kind words David... Glad you found the video useful :)

[@ahmedadam7259]

Yes Great job

[@clintonkingston6983]

Hi Sumit. Please carry on doing what you do ! This video helped me immensely - straight to the point and your advice works!! I watched a few other videos before yours about how to hide zero value cells and they ramble on and on with complicated formulaes to use. I find your videos to be well explained and helpful, thank you !!

[@Ricardo62446]

Sir, you are a king :) I was searching the whole internet for this. Thank you very much!

[@sofiaribeiro1149]

Thank you!!! You explanations are straight forward, no chitchat, extremely useful!! I've learned a lot of new things and I thought I know a lot ;) Great job!

[@finnhoydal2028]

Looked at a ton videoes above "remove zero values" pivot etc, with no resolve. Then, finally, you helped me remove them on the cell value level. Thanks!

[@lauriemccormack901]

Thanks so much for you excellent video. I have used simple formula to give a blank result and have looked for a simple way using custom formatting. Following your video has produced the outcome that I wanted. Once again, thank you so much.

[@wayneedmondson1065]

Hi Sumit.. thanks for the great tips.. very useful and helpful to have multiple ways to hide or otherwise remove/replace zero values in a data set. Thanks for sharing your knowledge. Thumbs up!!

[@womenadrift3811]

Thank you so much for this! The first option is exactly what I needed, and will be able to apply this to other projects that I do for graphing. You have just saved me hours of time!

[@kiranpekhale2469]

Thank you for sharing

[@dragandjukanovic3481]

You was short and simple. BRAVO

[@WorldWideMusic2000]

one of the most important options that nobody told me before, thank you!

[@reknowl]

Quick answers, I love it!
Thank you!

[@craighibbard2325]

I've been waiting my whole life for this video, amazing

[@mishraamukesh]

Your all tutorials are very useful to me.
Thanks

[@Exceltrick4u]

Thanks for this video. It is really helpful 👌🏻

[@dnl1120]

Finally a tutorial I can understand that is useful. Thank you so much!

[@surjagain]

Thank you for this extremely helpful video :)

[@Melanie_Ann]

dude. thank you so freaking much for this!

[@rajanphadke]

thanks for multiple solutions - Gives energy to learn more

[@Nevir202]

Thanks, was super helpful, even though I didn't use it at all.
Watched it, and it made me realize that since what I wanted to hide was zeros and errors from a formula, I just needed to add an IF at the start that checked if there was data in the cells it was operating on, and if not left the cell blank, which looked like this:
=IF(--cell-name--=0,,( --formula here-- )

[@jvlm3091]

Excellent and thorough explanation; thanks!

[@anandsh2276]

Excellent tutorial. This helped. Thank you so much. God bless.

[@steve924s2]

Very useful information, well explained 👍

[@CentralAssassin]

Thank youu!!

[@prakashsathyapriya]

Sir, finally i got my doubt cleared from this video. I need one more clarification from you. When working with data set in decimals how to suppress leading or trailing zeros. Hope you would clear asap. Thanks

[@lukmanariyuki2216]

Excellent 👍🏻, thank you

[@KaileshHambireIJ-G-]

Excellent Video made by you, Cleared all Queries related to hide or delete zero, I have made Tax invoice which is followed by linking all the sells of delivery challan that automatically fills data in Tax invoice , Now without showing zero values. It helped me a lot. Thank you once again.

[@trumpexcel]

Glad you found the video helpful Kailesh 🙂

[@rajeevajitsariya6739]

Excellent explanation and clarification.

[@SHEQXEL]

Good stuff. You just solved my problem.

[@wootwoot4422]

Huge thank you! Great content man!

[@sherion80]

Thank you! You helped me out.

[@pixipui]

THANK YOU!!
I'd written my =IFNA value correctly but that was getting me everytime.
Great vid :D x

[@davecarloscalixto8294]

Very helpful. Thanks.

[@Fazwaans]

Thanks for sharing your knowledge with everyone, It worked :) only thin have now the clountblank formula not working now ....

[@rabiaabenmbarek6007]

Thanks mate, this was great 👍 keep up the good work

[@natanaels.ndilenga4807]

Very helpful. Thanks a lot!!!

[@JarasS]

Great tutorial, thanks man!

[@dklh80]

Superb, truly a useful piece of information that actually makes productivity better

[@djoniamman5318]

Thanks a lot for amazing tutorial

[@ablorhadjei3174]

Thanks for your excellent teaching. 👍

[@sunethraaponsu4672]

Thanks a lot. It was very useful.

[@vb2369]

Excellent tutorial!! thank you .

[@KP-kj8fs]

great yaar...this is very useful

[@9Dan22]

Life saving tips thank you

[@karthikk4587]

Thank you very much sir!

[@fazalhussain1742]

Appreciate your help

[@arkady714]

Excellent video. Cheers, mate.

[@whoopa6]

EPIC. SOO helpful thanks legend!

[@bebsllance2455]

Excellent. Thank you so much. This is very useful. I have subscribed.

[@bucklandgroupllc4411]

Very Helpful, thank you

[@tarasherlock2712]

thanks for your last tip. I was wracking my brain on how to find and replace "0" with no value at all. @7.40 . It was playing havoc on my datasets when I was trying to determine Min/Max/Modes

[@MwanaWevhu]

Thank you for putting a time stamp🤗 I was looking for that also

[@ramzein776]

Thanks and very useful

[@georgia2354]

THANK YOU THANK YOU THANK YOU!!!!!

[@jaideepbalhara637]

A huge thank brother.....

[@VijayKumar-hk7uv]

Really helpful!!!!
Then saves mah time man
Do more stuff like this
You've earned a sub

[@You68688]

Great video man!

[@Tina-iz8qr]

Got my answer after 2 mins, thank you so much

[@jereyesjr]

Awesome!! Thank You!!

[@Tinyline]

Thank you!

[@86jorj]

Thank you so much!

[@mrrex11]

You are good! Thanks.

[@animateyourdreams7493]

Thanks man, helped a lot 😎

[@devangshah129]

THANK YOU VERY MUCH SIR

[@86jorj]

This is very helpful. I have a question though. I recently made a chart in spreadsheet showing year,months, and days worked in one cell, i was able to hide zeroes (i dont need to appear on the chart) with your help (thanks again) but the value 0years0months0days still appear selected cells despite having no corresponding entry. Please help me on how to hide such value. Thanks in advance.

[@saimohanveera9343]

So help Full thank a lot bro ❤️❤️❤️

[@aziztualhubiderie730]

Thank you very much

[@dysprosium162]

Many thanks man! :)

[@lotus3705]

U saved my life..

[@sonukumar-ul6tz]

Very helpful video

[@Ali-uz8qg]

OK Found an answer to my problem. Thank you. 7:35

[@SujeshKRamu]

thank you

[@thaneethanee6072]

excellent!!

[@kluelesstv1255]

Thank you so much...

[@maciejka4793]

many thanks

[@unknownjk22]

THANK YOU BROTHER.

[@hanumanjipankaj]

Thanks brother

[@santudey4130]

Thank you 😊

[@basictipsandtools4380]

Wow. Thank you so much. You have new subsciber

[@trumpexcel]

Glad you found the video useful!

[@hemantakumardas7574]

Very useful

[@fazalhussain1742]

Great Job

[@mortezamostafavi8112]

that was perfect.

[@hamzariaz2859]

You are just love ❤️❤️🔥

[@ram-it.damn-it]

Helpful video! Can u also put some video on how can we show dash sign "-" only instead of zeroes. Sometimes we have $ amts. and want to show dash where it is zero. Thanks!

[@trumpexcel]

I have covered this here - trumpexcel.com/hide-zero-values-excel/#Replace-Zeros-with-Dash-or-Some-Specific-Text

[@kkarsd]

Helpful..

[@floydmartyres9157]

Thanks a ton

[@shahzadsami5613]

Always Great

[@kotinsoelay9600]

thanks

[@MwanaWevhu]

Thank you

[@hamimuidrisa6390]

Ooh yes. thank you very much

[@sandhyarani8487]

Nice information
If the cell have 0 and that related line also to be disabled
Can u help me about that

[@chandranidutta7747]

Excellent

[@technicalsupport435]

Thanks Sir

[@PavanKumar-zg4zg]

Hi I have a question in the table abcd in d cell value is 0 I have to delete the value 0 row in the table how to do it.

[@softmetalic7]

excellent superb

[@omprakashbhoyar9491]

Thanks

[@mankeratsingh6272]

Thanku so much

[@keeloraz9452]

Soooo useful

[@fazalhussain1742]

Sir... Thanks

[@prithvisahay269]

Great🙏

[@shivshakti4495]

Can u tell me if I keep c4 cell empty than d8 I can blank cell is their any formula for that please

[@iamrawfilmmaker]

Thank you for this tutorial. I have another problem. When linking two Excel sheets, empty cells are transformed into zero and empty cells of money keeps there quotes such as ( - CFA, - $ ... ) how to hide its values when the cell does not contain data?