Hide Zero Columns

Hide Zero Columns makes your reports tidier and more readable by automatically hiding columns that only have zero values.

To use this function, just select a range of columns, an individual row or multiple rows and click Hide Zero Columns:

Velixo Reports will automatically hide all columns where every selected column in your selection is zero. Empty columns 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 columns that are hidden, press Ctrl + Shift + 0 or use Unhide command in the Excel contextual (right-click) menu:

You can also use Format menu in Cells section of Home tab in the ribbon: