Step 3: The first four columns are frozen. Select “freeze panes,” as shown in the succeeding image.Īlternatively, press the shortcut keys “Alt+W+F+F” one by one. Step 2: In the View tab, click the “freeze panes” drop-down under the “window” section. This is because the first four columns are to be frozen. 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.
![latest version of excel how to freeze column header latest version of excel how to freeze column header](https://bettersolutions.com/excel/rows-columns/freezepanes-frozencells.png)
#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.
![latest version of excel how to freeze column header latest version of excel how to freeze column header](https://excelmaster.co/wp-content/uploads/Freeze-Panes-Excel.jpg)
![latest version of excel how to freeze column header latest version of excel how to freeze column header](https://venturebeat.com/wp-content/uploads/2018/06/image4.png)
![latest version of excel how to freeze column header latest version of excel how to freeze column header](https://i.ytimg.com/vi/_wuF0lVW4b0/maxresdefault.jpg)
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.