You can “freeze” a column with data to make it always visible on the screen independently of horizontal scrolling.
To freeze columns, use the freezeColumns method. Columns are fixed starting from the very left one, so you should pass the amount of columns to freeze, starting from 0 (zero) to the method:
If the parameter isn't passed, the method will unfreeze the frozen columns, if there any.
There is also a possibility to freeze rows, to make some of them remain at the very top of the sheet.
To freeze rows, apply the freezeRows method. As a parameter you should pass the number or rows that should be frozen,starting from 0.
Without parameters the method unfreezes the frozen rows, if there are any.Back to top