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.

⚙️ Gear I Recommend:

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!

[Ricardo]

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

[sofiaribeiro]

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!

[asawa]

Thank you so much! This is what I was after. Your video is very informative and easy to understand!

[finnhoydal]

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!

[WorldWideMusic]

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

[craighibbard]

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

[clintonkingston]

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 !!

[dnl]

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

[mishraamukesh]

Your all tutorials are very useful to me.
Thanks

[womenadrift]

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!

[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.

[dklh]

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

[anandsh]

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

[rajanphadke]

thanks for multiple solutions - Gives energy to learn more

[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

[jvlm]

Excellent and thorough explanation; thanks!

[lauriemccormack]

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.

[pixipui]

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

[reknowl]

Quick answers, I love it!
Thank you!