The "Hide Zero Rows" button makes your reports tidier and more readable by automatically hiding rows that only have zero values.
To use this function, just select a range of rows, an individual column or multiple columns and click the Hide Zero Rows command.
Velixo Reports will automatically hide all the rows where every selected column in your selection is zero. Empty rows are ignored to ensure the layout of your report is not impacted.
To show all rows and columns that are hidden use Unhide All:
To show rows that are hidden, press Ctrl + Shift + 9 or use the Unhide command in the Excel contextual (right-click) menu:
You can also use the Format menu in the Cells section of the Home tab in the ribbon: