Estimated reading time: 3 minutes

Function Summary

The jFreezePanes function freezes a designated pane so the user can scroll through data and still keep the frozen pane in view. The function also hides a designated range of the report, typically the configuration section of an Interject report. This provides the user with a more user-friendly simplified viewing experience.

This action can be triggered by the Freeze/UnFreeze Panes found in Quick Tools on the Interject Ribbon Menu. There is also an option there to Freeze All Tabs, which will freeze all sheets containing the jFreezePanes function (it will not unfreeze the panes).

For an example of this function, see Lab Create: Customer Aging.

Function Arguments

Type Range
If Blank Function Error

Type Range
If Blank Will display all rows

Excel Formula Bar Example


Function Composition

Argument Name Example Mapping Explanation
Function Name =jFreezePanes() The name of this function.
FreezePanesCell A22 Row 22 will be frozen in place and all rows from 23 on will be able to scroll.
AnchorViewCell A15 Row 15 will be the topmost row in view after a freeze panes action.