Freeze Panes in Excel

VB C#

using IronXL;
using System.Linq;

WorkBook workBook = WorkBook.Load("sample.xls");
WorkSheet workSheet = workBook.WorkSheets.First();

// Create freeze pane from column(A-B) and row(1-3)
workSheet.CreateFreezePane(2, 3);

// Overwriting freeze or split pane to column(A-E) and row(1-5) as well as applying prescroll
// The column will show E,G,... and the row will show 5,8,...
workSheet.CreateFreezePane(5, 5, 6, 7);

workBook.SaveAs("createFreezePanes.xls");

// Remove all existing freeze or split pane
workSheet.RemovePane();

Imports IronXL
Imports System.Linq

Private workBook As WorkBook = WorkBook.Load("sample.xls")
Private workSheet As WorkSheet = workBook.WorkSheets.First()

' Create freeze pane from column(A-B) and row(1-3)
workSheet.CreateFreezePane(2, 3)

' Overwriting freeze or split pane to column(A-E) and row(1-5) as well as applying prescroll
' The column will show E,G,... and the row will show 5,8,...
workSheet.CreateFreezePane(5, 5, 6, 7)

workBook.SaveAs("createFreezePanes.xls")

' Remove all existing freeze or split pane
workSheet.RemovePane()

Install-Package IronXL.Excel

Freeze Panes in Excel

The code example above shows how to create a freeze pane, locking rows and columns in place, allowing them to remain visible while scrolling. It is a very useful feature to keep the header column or row in place while quickly comparing information.

`CreateFreezePane(column, row)`

The first CreateFreezePane method overload takes the column and row amount to create a freeze pane based on it. For example, workSheet.CreateFreezePane(1, 4) will create a freeze pane from column(A) and rows(1-4).

`CreateFreezePane(column, row, subsequentColumn, subsequentRow)`

This overload creates a freeze pane based on the column and row amount provided as well as applies scrolling to the worksheet. For example, workSheet.CreateFreezePane(5, 2, 6, 7) will have a freeze pane from columns(A-E) and rows(1-2) with 1 column and 5 row scroll. When the worksheet is first opened, it will show columns A-E, G-... and the rows will show 1-2, 8-...

If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.

You can download a project file from this link.

How to Add Freeze Panes in Excel Using C#

Download a C# library to add freeze panes in Excel
Load an existing spreadsheet or create a new one
Use the CreateFreezePane method to add freeze panes
Specify the third and fourth parameters to apply pre-scrolling
Export the edited Excel file

Navigate to the "Freeze Panes" How-To article for more information and demonstrations.

// Example of how to use CreateFreezePane method in C#
// Assume that 'workSheet' is a valid Excel worksheet object

// This will freeze the first column and the first four rows.
// Column A and rows 1-4 will remain visible while scrolling.
workSheet.CreateFreezePane(1, 4);

// This will freeze columns A-E and rows 1-2 and sets the scrollable area.
// When opened, the view will start from column F and row 8.
workSheet.CreateFreezePane(5, 2, 6, 7);

// Note: The first two parameters define the pane to freeze.
// The third and fourth parameters define the starting position of the scrollable area.

// Example of how to use CreateFreezePane method in C#
// Assume that 'workSheet' is a valid Excel worksheet object

// This will freeze the first column and the first four rows.
// Column A and rows 1-4 will remain visible while scrolling.
workSheet.CreateFreezePane(1, 4);

// This will freeze columns A-E and rows 1-2 and sets the scrollable area.
// When opened, the view will start from column F and row 8.
workSheet.CreateFreezePane(5, 2, 6, 7);

// Note: The first two parameters define the pane to freeze.
// The third and fourth parameters define the starting position of the scrollable area.

' Example of how to use CreateFreezePane method in C#
' Assume that 'workSheet' is a valid Excel worksheet object

' This will freeze the first column and the first four rows.
' Column A and rows 1-4 will remain visible while scrolling.
workSheet.CreateFreezePane(1, 4)

' This will freeze columns A-E and rows 1-2 and sets the scrollable area.
' When opened, the view will start from column F and row 8.
workSheet.CreateFreezePane(5, 2, 6, 7)

' Note: The first two parameters define the pane to freeze.
' The third and fourth parameters define the starting position of the scrollable area.

$vbLabelText $csharpLabel