jFreezePanes()


Function Summary

Addition to the quick tools menu that allows for quick freezing and unfreezing of sheets.

 

Parameter Name

Description

Default

Optional

FreezePanesCell

Specifies what cell the freeze will be attached to. The row above this cell will continue to be visible as you continue scrolling

 

NO

AnchorViewCell

Specifies what row will be at the very top of the sheet after the freeze is executed

 

NO

 

 

Formula



=jFreezePanes

   (

       FreezePanesCell

       ,AnchorViewCell

   )


 


 

Function Composition

FromFile

Worksheet

Inventory Demo

InventoryByCategory

=jFreezePanes ( A21 ,13:13 )