The steps for freezing multiple excel columns are listed as follows: Working on the data of example #1, we want to freeze the first four columns, A, B, C, and D. The shortcut to freeze multiple excel columns is “Alt+W+F+F” (when pressed one by one). Likewise, to freeze the rows 1, 2, and 3, select the cell A4. By freezing the first three columns, they remain visible to the user at all times. Similarly, for freezing multiple rows, select the first cell immediately below the last row to be frozen.įor example, to freeze the columns A, B, and C, select the cell D1. This is because multiple columns are frozen based on the current selection. For freezing multiple columns, select the first right-hand side cell immediately after the last column to be frozen. #2 Freeze Multiple Columns in Excelįreezing multiple excel columns is similar to freezing multiple rows. In the same way, the first row can be frozen. The same is shown in the following image. On scrolling (from left to right) through the remaining columns of the dataset, column A is visible.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.