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.
Please note, that we recommend leaving the opposite argument of Hide to be left blank, IF(E4=0,"Hide",""), rather than using non Jet Keywords such as Show. -
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