Overview
Automatically hiding entire rows or columns can be accomplished by including the HIDE keyword in the first cell of the column or row you want to hide:
Always hiding a worksheet (once a report has been run) can be accomplished by using the keywords AUTO+HIDE+HIDESHEET in cell A1 of that worksheet.
Occasionally, you may want to hide entire rows, columns, or even worksheets - all based on some criteria that may or may not be present. This is referred to as Conditional Hiding.
Hiding a Row
-
Place HIDE+? in cell B1
-
Use a formula to return Hide in column B of any row you want hidden.
In this example, let's hide any row where the Balance (in column E) is equal to zero.
-
When we run the report...
we see that there are no zero balances and we can see that rows 4-10, 12-14, and 19 have been hidden.
Hiding a Column
-
Place HIDE+? in cell A2
-
Use a formula to return Hide in row 2 of any column we want to hide.
In this example, let's hide the column if the Balance (in row 6) is equal to zero.
-
When we run the report...
we see that there are no zero balances and we can see that columns C-J and L-N have been hidden.
Hiding a Sheet
Similar to hiding a column, you can also hide an entire sheet
-
Place HIDE+? in cell A2
-
Use a formula to return HideSheet in cell B2 if our condition is met.
In this example, let's hide the worksheet if the Grand Total (in cell F6) is less than a particular amount.
-
When we run the report...
we see that the entire Report sheet has been hidden.
Comments