How to Unhide Rows and Columns

This article describes how to go from a table that has hidden rows or columns, such as "Less than $15,000" and "$200,001 or more" in this example:

To a table in which the hidden rows or columns are now shown:

Requirements

A table with hidden rows and/or columns.

Select the table.
In the object inspector , click either Data > Unhide Rows and Columns > Unhide Categories Shown in Rows or Data > Unhide Rows and Columns > Unhide Categories Shown in Columns.
In this example, we will unhide hidden columns.
Select from the list of columns you want to unhide.
Click OK.

Note that this method will reset all rows/columns, rather than being able to select specific ones to unhide.

Technical details

This tool cannot be used to unhide columns if the variable set selected in the Columns of the table:

Has the Structure of Text. Rows and columns of text data cannot be hidden.
Has the Structure of Date/Time. To choose which dates to include for data of this type, select the variable in the Data Sources tree and then use Data > Properties > Date/Time in the object inspector .
Is a Banner. Data for banners is linked to the underlying questions. You will need to select the banner under the Data Sources tree and then use Object Inspector > Data > Properties > Reset.