Hide Columns, Cells and Tables

Introduction

"Hiding" is the act of making a column, table or non-contiguous cell invisible. Non-contiguous cells are individual cells that are not part of a table, such as a title or a pre-defined cell. See the Add Cells Guide for more information.

Hiding columns has a slightly different function than hiding whole tables or non-contiguous cells. Because hidden columns are not actually deleted, the tables they are part of still behave as they would if the columns were visible. This includes displaying rows that look like duplicates of each other: without the invisible column, these would "roll up" and display only one row with those values.

Hiding a column can be helpful in situations where a column must be part of a table to maintain row level specificity, but is undesirable or a bother to look at. This can also be used for custom table sorting or ranking, the built-in Sorting and Ranking functions are not adequate. See the Sorting  and Ranking Guides for more information.

Tables or non-contiguous cells can be hidden conditionally, meaning that you can define when a cell or table shows and when it does not. When the elements are invisible, the report will visually present as if they had been deleted. Thus, the value of hiding tables or non-contiuous cells is including or excluding these elements in a report automatically.

Note: Although an element can stay hidden if the report is saved, other users have the capability to un-hide any elements at any time. Therefore, this is not a secure choice for obscuring personal or sensitive data.

We recommend documenting the existence of the hidden elements on the purpose page or with a note in the header or footer. This way, hidden elements will not be forgotten when they are not showing.

Video


Hiding Columns

Prerequisite: Have your report open and make sure it is in Design Mode.

Note: If you are interested in using the hidden column for custom ranking and sorting, first create a custom variable that reflects your desired system. See our Variables Guides for more information on how to do this.

1. Create your table, including the column that you want to make invisible.

Note: For sorting and ranking, place your to-be-hidden column first. Or, apply the desired sort.

2. Right-click (control + click on a mac) on your column (not the header).

Screenshot of InfoView right-click menu showing where the hide option is

3. In the menu, select "Hide", then "Hide Dimension"

Your Column will no longer be visible.

Screenshot of InfoView table with hidden column

Note: You will still be able to see your column in the "Document Structure and Filters" view in the left-navigation area.

Screenshot of InfoView document structure showing hidden column

4. To un-hide your dimension, right-click (control + click on a mac) on any part of the table, select "Hide" and then "Show Hidden Dimensions". Your column will reappear.

Screenshot of InfoView menus showing how to unhide dementions

Hiding Tables and Cells Conditionally

1. Navigate to the Format Table or Format Cell Menu. See the Format Menus Guide for more information on how to do this.

Screenshot of InfoView showing the Format Table menus and the hiding options

2. Make your hiding selections, or define a formula that determines when the table or cell is visible and when it is hidden.

Note: When your table or cell is hidden, you will not be able to see it in normal Design Mode. However, you will be able to see it in Structure Mode. See the Structure Mode Guide for more information on how to use Structure Mode.

Screenshot of InfoView showing the hidden table in structure mode

You will also be able to see it in the "Document Structure and Filters" view in the left navigation.

Screenshot of InfoView showing the hidden table in the document structure panel