This article describes how to go from a table which 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:
A table with hidden rows and/or columns.
Method 1 - via the object inspector
- Select the table.
- In the object inspector, click either Inputs > UNHIDE ROWS AND COLUMNS > Unhide Categories Shown in Rows or Inputs > UNHIDE ROW 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.
In this example, we will unhide the "$200,001 or more" column but leave the "Less than $15,000" column hidden.
- Click OK.
The results are as follows:
Method 2 - directly from the table
Note that this method will reset all rows/columns, rather than being able to select specific ones to unhide.
- Right-click any row or column on the table.
- Select Reset Table Categories.
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 under Data Sets and then use Properties > GENERAL > 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 Data Sets and then use Properties > DATA VALUES > Reset.
How to Hide Empty Rows and Columns in a Table
How to Hide and Unhide Variables and Variable Sets
How to Hide Rows Below a Specified Value
How to Hide Rows or Columns with Small Sample Sizes
How to Hide Rows and Columns with Small Sample Sizes in a Table
Article is closed for comments.