How to Show or Hide Zero Values in Excel Office 365? – [with Example]
Tags: kutoolsexceltutorial, showorhidezerovalues, kutools
Published: 2020-10-08 08:05:55

---
title: How to Show or Hide Zero Values in Excel Office 365? – [with Example]
published: true
date: 2020-10-08 03:59:30 UTC
tags: KutoolsExcelTutorial,ShoworHideZeroValues,Kutools
canonical_url: https://geekexcel.com/how-to-show-or-hide-zero-values-in-excel-office-365-with-example/
---

In this post, you will understand how to **Show or Hide Zero Values in Excel Office 365** using **kutools.** Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Show/Hide Zero Values in the Spreadsheet:

To show or hide the zero values in the worksheet, do as follows.

- First, you need to enable the **Design Tab. ** To do this, on the **Kutools Plus Tab, select** the **Worksheet Design** option.

![select the Worksheet Design option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/EXCEL_cJkt0ALDpj.png)<figcaption id="caption-attachment-15195">select the Worksheet Design option</figcaption>

- Now, it will show the **Design Tab,** where you can see the **Show Zero** option.

![Design Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Design-Tab-1.png)<figcaption id="caption-attachment-15334">Design Tab</figcaption>

- Let’s consider the below example data where you can see the **range of cells with the zero values** that are highlighted in this screenshot.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-data-5.png)<figcaption id="caption-attachment-15335">Example data</figcaption>

- On the **Design** Tab, you need to **check** the **Show Zero** option to **display all the zeros** is the selected range.

![Enable Show Zero option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Enable-Show-Zero-option.png)<figcaption id="caption-attachment-15336">Enable Show Zero option</figcaption>

- If you want to **hide the zeros** in the range, then **uncheck** the **Show Zero** option.

![Hide Zeros](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Hide-Zeros.png)<figcaption id="caption-attachment-15337">Hide Zeros</figcaption>

### Note:

- The **Show Zero** option works for the whole worksheet.
- If you want to **close** the **Design Tab,** you need to **click** the **Close Design** option in the **Options** Tab under the **Design Tab.**

![Close Design option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Close-Design-option.png)<figcaption id="caption-attachment-15338">Close Design option</figcaption>

## Verdict:

In the above article, you can easily understand the steps to **Show or Hide Zero Values in Excel Office 365** using **kutools.** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See Also:

- [How to Insert Bullets or Numberings in Multiple Cells in Excel Office 365?](https://geekexcel.com/how-to-insert-bullets-or-numberings-in-multiple-cells-in-excel-office-365/)
- [Find and Fill Missing Numbers in a Sequence in Excel](https://geekexcel.com/find-and-fill-missing-numbers-in-sequence-in-excel-office-365/)
- [Calculate Age By Date of Birth in Excel](https://geekexcel.com/how-to-calculate-age-by-date-of-birth-in-excel-office-365/)