Suppress & Hide Zeros and Blanks
How to hide rows with all zeros or blank values in your OfficeConnect workbook.
Zero suppression in OfficeConnect 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.
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:
- Select the row
- Right-click → OfficeConnect → Row Properties
- Set 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.