This topic explains how to freeze columns and/or rows and how to split the worksheet in several panes.
The following topics are prerequisites to understanding this topic:
This topic contains the following sections:
The following table explains briefly the configurable aspects of the freezing and splitting features. Further details are available after the table.
You can freeze row(s) at top or column(s) at left of a worksheet using the freezing panes features. Frozen row(s) and/or column(s) remain visible at all time while the user is scrolling. The frozen row(s) and/or column(s) are separate from the rest of the worksheet by a single solid line, which cannot be moved.
The following table maps the desired configuration to the FrozenPaneSettings object’s properties that manage it.
The following example code demonstrates how to freeze rows and columns. The example code assumes you have a reference to a worksheet object named worksheet1:
In Visual Basic:
worksheet1.DisplayOptions.PanesAreFrozen = True
' Freeze first row in worksheet
worksheet1.DisplayOptions.FrozenPaneSettings.FrozenRows = 1
' Freeze first 2 columns in worksheet
worksheet1.DisplayOptions.FrozenPaneSettings.FrozenColumns = 2
' The 4th column is displayed first after the frozen columns
worksheet1.DisplayOptions.FrozenPaneSettings.FirstColumnInRightPane = 4
' The 3rd row is displayed first after the frozen row
worksheet1.DisplayOptions.FrozenPaneSettings.FirstRowInBottomPane = 2In C#:
worksheet1.DisplayOptions.PanesAreFrozen = true;
// Freeze first row in worksheet
worksheet1.DisplayOptions.FrozenPaneSettings.FrozenRows = 1;
// Freeze first 2 columns in worksheet
worksheet1.DisplayOptions.FrozenPaneSettings.FrozenColumns = 2;
// The 4th column is displayed first after the frozen columns
worksheet1.DisplayOptions.FrozenPaneSettings.FirstColumnInRightPane = 4;
// The 3rd row is displayed first after the frozen row
worksheet1.DisplayOptions.FrozenPaneSettings.FirstRowInBottomPane = 2;You can use the splitting panes feature to split the worksheet into two (either horizontal or vertical) panes or four panes. Each pane supports scrolling, however panes on one column will share the same horizontal scrollbar and panes on one row will share the same vertical scrollbar. The split panes are separated by a double border which supports resizing.
The following table maps the desired configuration to the UnfrozenPaneSettings object’s properties that manage it.
The following example code demonstrates how to split rows and columns. The example code assumes you have a reference to a worksheet object named worksheet1:
In Visual Basic:
worksheet1.DisplayOptions.UnfrozenPaneSettings.FirstColumnInLeftPane = 0
worksheet1.DisplayOptions.UnfrozenPaneSettings.FirstColumnInRightPane = 5
worksheet1.DisplayOptions.UnfrozenPaneSettings.FirstRowInTopPane = 0
worksheet1.DisplayOptions.UnfrozenPaneSettings.FirstRowInBottomPane = 3
' left pane will be 150 points width
worksheet1.DisplayOptions.UnfrozenPaneSettings.LeftPaneWidth = 150 * 20
' top pane will be 100 points height
worksheet1.DisplayOptions.UnfrozenPaneSettings.TopPaneHeight = 100 * 20In C#:
worksheet1.DisplayOptions.UnfrozenPaneSettings.FirstColumnInLeftPane = 0;
worksheet1.DisplayOptions.UnfrozenPaneSettings.FirstColumnInRightPane = 5;
worksheet1.DisplayOptions.UnfrozenPaneSettings.FirstRowInTopPane = 0;
worksheet1.DisplayOptions.UnfrozenPaneSettings.FirstRowInBottomPane = 3;
// left pane will be 150 points width
worksheet1.DisplayOptions.UnfrozenPaneSettings.LeftPaneWidth = 150 * 20;
// top pane will be 100 points height
worksheet1.DisplayOptions.UnfrozenPaneSettings.TopPaneHeight = 100 * 20;The following topics provide additional information related to this topic.