The column AB shown in the following image is the last scrolled column of the dataset. The grey line appears at the end of column A indicating that the column to the left is frozen. Select вЂњfreeze first column,вЂќ as shown in the succeeding image.ДЄlternatively, press the shortcut keys вЂњAlt+W+F+CвЂќ one by one.

In the View tab, click the вЂњfreeze panesвЂќ drop-down under the вЂњwindowвЂќ section.

Select the worksheet where the first column is to be frozen.

The steps for freezing the excel column are listed as follows:

The excel shortcutВ to freeze the first column is вЂњAlt+W+F+CвЂќ (when pressed one by one). In addition, column A is fixed irrespective of the column from which the actual data begins. This means that on moving from left to right, this column will be visible at all times. #1 Freeze the First Column in ExcelДЇreezing the first column locks column A of the worksheet. Let us go through the ways of freezing the first excel column, multiple columns, and both rows and columns. This line indicates that the row or column has been frozen.

Freeze first columnвЂ“It freezes only the first column.ДЄfter freezing a row or column in excel, a grey line appears at the end of the frozen area.

Freeze top rowвЂ“It freezes only the first row.

Freeze panesвЂ“It freezes multiple rows and columns.

read moreвЂќ drop-down under the View tab lists the following options: The вЂњ freeze panes Freeze Panes Freezing panes in excel helps freeze one or more rows and/or columns so that they remain fixed while scrolling through the database. In other words, the frozen columns save the scrolling time of the user.ДЄll the properties of the frozen column apply to the frozen row as well.

To facilitate comparison of different columns of the worksheetДЇreezing columns prevents the user from referring to the same column again and again.

To ensure that the user does not lose track of the specific column.

The objectives of freezing an excel column are:

Moreover, if column A consists of headings, the user may want to view these while working on the other columns of the dataset. A frozen column does not move with the movement of the remaining columns.ДЇor example, freezing the first column (column A) ensures that it stays at its place at the time of navigation through the rest of the columns. Freezing columns in excel fixes or locks them so that they remain visible while scrolling through the database.

How to freeze frame in excel mobile