Freeze First Column(s) of Excel Worksheet

Introduction

In this article, we will learn how to freeze left column(s). When you have a huge amount of data in a row, you are unable to see the left columns when horizontally scrolling the worksheet. You can freeze and lock the first column(s) so that you can see that frozen portion even when the rest of the data are being scrolled. You can easily see headers in the left columns.

How to Freeze Columns In Excel

1. If you want to freeze left column(s), first select the column to the right of the column that needs to be frozen.
2. Click View > Freeze Panes.
3. On the drop‑down menu, click Freeze First Column.
4. If you scroll horizontally, the first column remains in view on the left.

As you can see, the first column is frozen; it remains locked on the left side of the view when you scroll horizontally.

Freezing columns lets you view your extensive data while keeping the first column visible.

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

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

1. Construct a Workbook to open the file or create an empty file.
2. Freeze the first column with the Worksheet.freeze_panes() method.
3. Save the file.

Attached sample source Excel file.