Hide zeros

Hiding zeros

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

"Hide zeros" button

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

Showing zeros

If you want to show the hidden rows or columns, click on the "Hide zeros" sub-menu in the Logicim 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.

Hiding zeros in a specific range

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.