Suppress & Hide Zeros and Blanks
How to hide rows with all zeros or blank values in your OfficeConnect workbook.
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 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
1
Open Workbook Properties
In the OfficeConnect ribbon, click Workbook Properties.
2
Check 'Hide rows with all zeroes'
In the Row Display section, check the Hide rows with all zeroes option.
3
Click Refresh
After refreshing, click Hide Zeros & Blanks in the OfficeConnect ribbon to activate suppression.
Per-row overrides
With the workbook default set, you can configure individual rows to behave differently:
4
Select the row
Click the row number to select the entire row.
5
Open Row Properties
Right-click the row and choose OfficeConnect → Row Properties.
6
Set the zero suppression behavior for this row
Choose a different zero suppression behavior for that specific row.
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 for the rest of the workbook-wide display settings
- Filter Your Data if you want to exclude rows by value or attribute rather than just hide zeros
- Display Percentage Values Correctly when suppression behavior interacts with rounded percentage rows