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:
- Freeze Panes: freezes both Column and Row Names
- Freeze Column Names: freezes Column Names
- 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 the Tools menu and select Page Master
In Page Master view, select APPEARANCE > Table panes > (choose the desired setting)
Once you have made all the desired changes, to return Normal view, click the button 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 View

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

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