LibreOffice Calc - Automatically hide Zero values

December 2016

To hide zero values under LibreOffice Calc:
  • Launch LibreOffice select the Calc application.
  • Click on Tools > Options.
  • Go to LibreOffice Calc > View.
  • In the "Display" section, uncheck "Zero values".

  • Click on OK to validate.

Related :

This document entitled « LibreOffice Calc - Automatically hide Zero values » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.