Excel: Hide null values - here's how

It is not always important that all values are displayed in Microsoft Excel. Every now and then, this can even lead to confusion. However, in Excel you have several options to customize the display options. Learn how to hide the zero value in your Excel document.

Hide all zero values on worksheet

In Excel, you have the option to hide all zero values on a worksheet. To do this, follow these steps:

1. Open the Excel file and switch to the worksheet on which you want to hide the zero values.
2. Click "File" in the navigation and then "Options".
3. Switch to "Advanced" in the overview to display additional setting options.
4. Uncheck the setting "Show a zero in cells with zero value" in the category "Options for this worksheet."
5. Confirm the changes with "OK".

Hide selected zero values

Alternatively, you can also hide only selected zero values in your document.

1. Select all cells containing a null value that you want to hide.
2. Click "Start" in the navigation and select "Format" in the "Cells" category and then "Format Cell".
3. Wählen Sie die Registerkarte „Zahlen“ aus.
4. Klicken Sie bei „Kategorie“ auf die Option „Benutzerdefiniert“.
5. Geben Sie in das Eingabefeld „Typ“ den Wert „0;-0;;@“ ein und bestätigen Sie die Eingabe, indem Sie auf „OK“ klicken.