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 Properties , select the Appearance tab.
From the Appearance > Table Panes menu, select 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: 26UI - Freeze Columns.gif
Now you can scroll to the right and still see the row names.

Unfreezing row and/or column labels

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

Setting the default in Page Master

Click Page Master at the bottom of the screen.
In Page Master view, go to Properties > Appearance > Table panes > (choose the desired setting).
Once you have made all the desired changes, click Exit Page Master .