Skip to main content

Hide Rows, Columns or Sheets Conditionally

Beginner

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:

hiding0.jpg

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

  1. Place HIDE+? in cell B1

    hiding1.jpg

  2. 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.

    hiding2.jpg

    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.

  3. When we run the report...

    hiding3.jpg

    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

  1. Place HIDE+? in cell A2

    hiding4.jpg

  2. 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.

    hiding5.jpg

  3. When we run the report...

    hiding6.jpg

    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

  1. Place HIDE+? in cell A2

    hiding7.jpg

  2. 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.

    hiding8.jpg

  3. When we run the report...

    hiding9.jpg

    we see that the entire Report sheet has been hidden.

Was this article helpful?

We're sorry to hear that.