Freeze Top Row(s) of Excel Worksheet

Introduction

In this article, we will learn how to freeze top row(s). When you have a huge amount of data under a common heading you are unable to see the heading when scrolled down the worksheet. You can freeze top row(s) so that you can see that frozen portion even when the rest of the datas are being scrolled. You can easily see headers in the top rows.

How to Freeze Rows In Excel

1. If you want to freeze top row(s), then first select the row under the row that needs to be frozen
2. Click View > Freeze Panes.
3. On the drop-down menu, click Freeze Top Row.
4. If you scroll down ,the first row is always in the top view.

As you can see 1st Row is frozen, the fist row always stay at the top of the view when you scroll down.

Freeze Rows let you view your large data without any keeping track of Row label.

How to Freeze Rows with Aspose.Cells for Python Excel Library

It’s simple to freeze row(s) with Aspose.Cells for Python via .NET. Please use the Worksheet.freeze_panes method to feeze row(s) at the selected row.

1. Construct Workbook to open the file or create an empty file.
2. Freeze the fist row with Worksheet.FreezePanes() method.
3. Save the file.

Attached sample source Excel file.