Hide Rows with Zero Balances

The Hide Rows with Zero Balances option analyzes the active worksheet or workbook, and performs a row hide function for any spreadsheet row containing GXL, GEXQ or ProSheet Account Data formulas, in which the net result is zero for all cells. This option is very effective for standardized reporting templates, such as departmental reports. Multiple rows may be created as a template, but the function will hide non-used or zero rows.

Hide Rows with Zero Balances on the Worksheet

In Excel, from the Spreadsheet Server Ribbon, select Hide Rows.

Hide Rows with Zero Balances in the Workbook

In Excel, from the Spreadsheet Server Ribbon, select Hide Rows > Hide Zero Balance Rows (Workbook).

Restore Hidden Rows on the Worksheet

In Excel, from the Spreadsheet Server Ribbon, select Restore Rows.

Restore Hidden Rows in the Workbook

In Excel, from the Spreadsheet Server Ribbon, select Restore Rows > Restore Hidden Rows (Workbook).