The Hide Zero Rows button makes your reports tidier and more readable by automatically hiding rows that only have zero values.


Basic Hiding

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 re-show all rows and columns that are hidden, use Unhide All:


Alternately, 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:


In version of Velixo Reports prior to 6.0.376, blanks are *not* treated as zeros. Newer versions of Velixo Reports allow you to choose how to treat blank values.

Auto Hide / Unhide

When using basic hiding, you need to manually unhide the rows before refreshing your report and then re-hide those rows that now contain the zero values you do not want to see.

Auto Hiding allows you to set your hiding criteria and then have Velixo Reports remember that and automatically hide zero rows and un-hide non-zero rows as the values in your report are refreshed.

The Auto Hide/Unhide feature is accessed through the pull-down on the Hide Zero Rows button:



Here is an example of the results of using the Auto Hide/Unhide Rows feature:


In the example, the original report show some zero values in column B. By selecting cells B4 though the last data value in column B, and then clicking Auto Hide / Unhide Rows in Selected Range from the Acumatica ribbon, those zero-value rows are hidden. (Velixo Reports will now remember the area to which you want to apply this hiding criteria. This area is referred to as the "Controlled Range")

Next, when the report is refreshed with new data, Velixo Reports automatically adjusts which rows are hidden, based on the new values in the report.

Auto Hide FAQ:

When does Velixo auto-hide/unhide controlled ranges?

Upon every workbook calculation (e.g. when you update a formula) as well as Velixo Refresh

When we use Excel's filtering feature in a table, Excel hides/unhides rows automatically. How can we get Excel to detect our auto-hide settings?

Select Reapply Auto-Hide Logic from the Hide Zero Rows pulldown list

Is it better to select entire columns or just the rows in each column to which I want to apply the Auto-Hide feature?

Because Excel allows over 1 million rows in any column, applying the Auto-Hide feature to all rows in multiple columns can take a while to evaluate. Must faster results can be obtained by selecting only the region of cells in which you can reasonably expect data to be contained.

What is the scope of auto-hiding of the range I select?

The current worksheet

Where can I review if there is any auto-hide range for the worksheet, and if there is, what is it?

From Excel's Formulas ribbon, select Name Manager and look for VelixoAutoHideZeroRows and AutoHideZeroColumns

Does "Auto-Hide in Selected Range" overwrite the previous range I selected for auto-hiding?

No, it combines the newly selected range with the already controlled ranges, now controlling auto-hiding / unhiding in the new united range

Can I manually edit the auto-hide range for the worksheet?


Normally, you would just use "Auto-Hide in Selected Range" button, but for some reasons you might want to edit the range manually.

On the Excel toolbar, go to the Formulas ribbon and select Name Manager and then edit the range

Because after such manual change there will be no calculation event, changes will not be automatically reapplied. To reapply them, you need to manually select just one of the controlled cells, click the pull down arrow on Hide Zero Rows and then click Auto-Hide / Unhide Rows in Selected Range. The changes will be reapplied across the entire controlled range, not just the selected cell.

How do forget all controlled ranges for the current worksheet?

From the Acumatica ribbon, click the pulldown arrow for Unhide All and click Forget Auto Hide/Unhide Ranges

What if I want to temporarily disable auto-hiding while I make changes, but then restore the ranges?

Go to the Formulas ribbon, select Name Manager and temporarily rename the VelixoAutoHideZeroRows and VelixoAutoHideZeroColumns ranges to something else.

When you're done, rename them back and see above for manually re-applying changes.

Did this answer your question?