How to Hide Zero Values in Google Sheets

Looking to hide zero values in Google Sheets? Here are my two favorite methods. Each protects your data, so those null values stay in your set without appearing in the cells.
For a complete guide, check out my article: spreadsheetpoi...
Note that you can copy/paste my formatting too. Here's what appears on screen about halfway through the video: 0;-0;;@
Subscribe to this UA-cam channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - / spreadsheetpoint
This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets
You can also find a lot of useful resources on Google Sheets here: spreadsheetpoi...
#GoogleSheets #GoogleSheetsTips #Spreadsheet

[@KiwiMum67]

Excellent solution, thank you!!

[@lordia79]

thank you very mutch!! Greetings from Italy

[@SpreadsheetPoint]

If you found this helpful, please give it a thumbs up and a comment. And let me know what else you'd like to see on Spreadsheet Point!

[@toni_jaay]

Thank you so much!

[@TeacherToMillionaire]

Quick question - what if I need some zeros but only IF another cell isn't empty (for a spending formula) but not other zeros if the category is blank? Would I use conditional formatting to say IF cell A1 is blank, hide that zero?

[@SpreadsheetPoint]

Yes, you could use conditional formatting that way!

[@mjcurtis5405]

Geez I love UA-cam. Thanks so much

[@jonathanz.9675]

Gracias so much

[@XoogwayX]

Thank you so much!!!!

[@SpreadsheetPoint]

Glad it helped!