---
title: "Suppress \u0026 Hide Zeros and Blanks"
url: "https://officeconnectpro.com/reference/troubleshoot/suppress-zeros-blanks/"
description: "How to hide rows with all zeros or blank values in your OfficeConnect workbook.\n"
tags: ["reporting","fpna","system-admin","troubleshoot"]
date: "0001-01-01"
lastmod: "2026-05-19"
---


Hiding empty rows in a Workday OfficeConnect report is a two-part system: **Workbook Properties** controls the *default state*, and the **Hide Zeros & Blanks** ribbon button is a *toggle* on top of that default. Review the full settings layout in [Workbook & Worksheet Properties](/wiki/build-reports/workbook-worksheet-properties/) so you set the default in the right place.

## How it works

| Workbook property | Effect |
|---|---|
| **Hide rows with all zeroes** is **checked** | Zero suppression is enabled by default. The **Hide Zeros & Blanks** button on the ribbon toggles it on/off. |
| **Hide rows with all zeroes** is **unchecked** | Zero suppression is disabled. The **Hide Zeros & Blanks** button will not work after refresh. |

## Enable zero suppression

{{< step n="1" title="Open Workbook Properties" >}}
In the OfficeConnect ribbon, click **Workbook Properties**.
{{< /step >}}

{{< step n="2" title="Check 'Hide rows with all zeroes'" >}}
In the **Row Display** section, check the **Hide rows with all zeroes** option.
{{< /step >}}

{{< step n="3" title="Click Refresh" >}}
After refreshing, click **Hide Zeros & Blanks** in the OfficeConnect ribbon to activate suppression.
{{< /step >}}

## Per-row overrides

With the workbook default set, you can configure individual rows to behave differently:

{{< step n="4" title="Select the row" >}}
Click the row number to select the entire row.
{{< /step >}}

{{< step n="5" title="Open Row Properties" >}}
Right-click the row and choose **OfficeConnect → Row Properties**.
{{< /step >}}

{{< step n="6" title="Set the zero suppression behavior for this row" >}}
Choose a different zero suppression behavior for that specific row.
{{< /step >}}

This lets some rows follow the workbook default while others always show (or always hide) zeros.

## Zero suppression and Excel's Hide Rows

Within OfficeConnect-linked data ranges, you can also use Excel's native **Hide** capability on rows and columns. These behave independently from OfficeConnect's zero suppression.

## Next steps

- [Workbook & Worksheet Properties](/wiki/build-reports/workbook-worksheet-properties/) for the rest of the workbook-wide display settings
- [Filter Your Data](/wiki/build-reports/filter-data/) if you want to exclude rows by value or attribute rather than just hide zeros
- [Display Percentage Values Correctly](/reference/troubleshoot/display-percentage-values/) when suppression behavior interacts with rounded percentage rows