Overview

Using Velixo's Hide Zero Columns feature 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 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: