Hiding zeros is available for all your workbooks, even if they do not use XLGL.

Click on the "Hide zeros" button in the XLGL ribbon. This will automatically hide the rows and columns that contain only zeros in your report.

If you want to show the hidden rows or columns, click on the "Hide zeros" sub-menu in the XLGL ribbon. From there, you can select "Unhide all" to show all hidden rows and columns, or choose "Unhide rows" or "Unhide columns" to selectively unhide specific areas.

If you only want to hide zeros in a specific range of cells, make a selection in your worksheet before clicking on the "Hide zeros" button. This will limit the effect of hiding zeros to the selected range.