How to Freeze Columns and Rows

When you have a large table, it can be difficult to keep track of the row or column names when you scroll. For example, in this table, it this table the variables Age, Income and Gender are in the banner and Cola Preference is in the Row. While I can see the relationship between Cola Preference and Age, I can't see all the columns in Income and I am unable to see the Gender columns at all:

While I can scroll to the right to see the additional columns, but when I do, I can no longer see the Row Names, which makes it harder difficult to keep track of what row I am on:

In this article, you will learn how to freeze rows and columns so scrolling is no longer an issue for tables that won't fit onto a single page.

Requirements

A Displayr table with scroll bars

Method

Freezing row and/or column names

Select the table.
In the Object Inspector, select the Appearance tab.
From the Appearance > Table Panes menu, select from one of the options:
1. Freeze Panes: freezes both Column and Row Names
2. Freeze Column Names: freezes Column Names
3. Freeze Row Names: freezes Row Names

For example, to freeze the Row Names in the previous table, you do the following:
Now you can scroll to the right and still see the row names.

Unfreezing row and/or column labels

Select the Table.
In the Object Inspector, select the Appearance tab.
Select Appearance > Table Panes > Unfreeze Panes.

Setting the default in Page Master

Click on Tools and select View Page Master.
In Page Master view, select Appearance > Table panes > (choose the desired setting).
Once you have made all the desired changes, click Exit Page Master at the top right of the screen.

For example, to set the default to Unfreeze Panes in Page Master:
freeze 2.gif

Changing the default in Explore Mode

The freeze / unfreeze settings can be changed in Explore Mode.

From the toolbar, click Edit. The Object Inspector will open on the right.
In the Object Inspector, select the Data tab.
Select Appearance > Table Panes > (desired option).