• Material 3
  • Fluent
  • Fluent 2
  • Bootstrap 5
  • Tailwind CSS
  • High Contrast
  • Fluent 2 High Contrast
Preferences
Mode Selection
Touch
Mouse
Theme Selection
Theme Mode
Localization
*Translated by Google Translator.
Currency

This sample demonstrates the Spreadsheet freeze pane feature by applying frozen rows and columns with the Gross Salary scenario as an example. In this sample, you can see the frozen rows/columns that are visible while scrolling the sheet content vertically/horizontally.

DEMO
DOCUMENTATION
SOURCE

Freeze Panes helps you to keep particular rows or columns visible when scrolling the sheet content in the spreadsheet. You can specify the number of frozen rows and columns using frozenRows and frozenColumns properties inside the `Sheet` property.

In this sample, the first 2 rows and columns are frozen using the `frozenRows` and `frozenColumns` properties.

Key Features

  • Freeze panes - Keep important rows and columns visible while scrolling through large worksheets for easier data navigation.
  • Frozen rows - Retain header rows at the top of the worksheet using the frozenRows property.
  • Frozen columns - Keep key columns visible during horizontal scrolling using the frozenColumns property.

Learn how to keep specific rows and columns visible while scrolling the sheet content, as demonstrated in this sample.

Documentation Link

More Resource