Modified 07 March 2017 by Ian Weatherhogg

Sometimes you need to see the data that is important in a Google spreadsheet - and get rid of annoying zeros, this tip helps you do just that.

In Microsoft Excel you can hide the 0 values in a spreadsheet, Google spreadsheet does not have this function yet. A clever work around though can be found by using conditional formatting.

  • Select all cells (Ctrl + A) click Format > Conditional Formatting
  • Use the dropdown to select Equal To and type 0
  • Tick the text tickbox and change the text color to white, this will effectively hide all your zero values.