Freeze rows and/or columns in a table so their names stay visible while you scroll — useful for any table with scroll bars that doesn't fit on a single page. Once you've frozen rows, columns, or panes, you can scroll through the rest of the table and still see which row or column you're looking at.
For example, in the table below, the variables Income, Gender, Living Arrangements, and Awareness are in the banner, and Cola Preference is in the Row. While you can see the relationship between Cola Preference and Income, you're unable to see all of the Gender columns, and cannot see the Living Arrangements and Awareness columns at all:
While you can scroll to the right to see the additional columns, you can no longer see the row names, which makes it more difficult to keep track of what row you're on:
Requirements
A Displayr table with scroll bars.
Method
Freeze row and/or column names
- Select the table.
- In Properties
, go to the Appearance tab.
- From Appearance > Table Panes, select one of the options:
- Freeze Panes: freezes both Column and Row Names.
- Freeze Column Names: freezes Column Names.
- Freeze Row Names: freezes Row Names.
Now you can scroll to the right and still see the row names:
Unfreeze row and/or column labels
- Select the table.
- In Properties
- Select Appearance > Table Panes > Unfreeze Panes.
Set the default in Page Master
- Click Page Master
in the Report tree.
- In Page Master view, select the page(s) in the Master tree to set the default on. Note: You must select pages that are labeled with "Content" to access the table panes settings.
- Go to Properties
- Once you have made all the desired changes, click Exit Page Master
.