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.