3 Easy steps to hide zero values in Excel

In order to have neat looking reports in Microsoft® Excel®, you may choose to hide zero values. In this tip, we explain how to hide zero values for selected cells by using the custom number format. The hidden zero values appear in the formula bar when a cell is selected. Values that change to non-zero digits will be displayed in the cell range.

You are welcome to download the workbook to practice.

Applies To: Microsoft® Excel® 2013 and 2016.

  1. Select the data range C3 to C24.
  2. Then press Ctrl+1 and select the Number tab then Custom.
  3. In the Type box, enter 0;;;@ then select OK.

To display hidden values:

  1. Select the data range C3 to C24.
  2. Then press Ctrl+1.
  3. Select the Number tab then General.
  4. Select OK.

The cells with zero values will display blank cells. This will give the report a neat look and make it more presentable.


Sage © Sage South Africa Pty Ltd 2016 . All Rights Reserved.