Now, when you scroll to the right to see the ‘City’ column (E), columns A and B will remain visible on the far left of your worksheet. In the following example, we wish to freeze the first two columns, so we are selecting the third column (C1).Īnd then click ‘Freeze Panes’ (first option) in the ‘Freeze Panes’ drop-down menu. To freeze multiple columns, select the column to the right of the last column you want to lock (freeze) when you scroll.
![is it possible to freeze multiple panes in excel is it possible to freeze multiple panes in excel](https://cdn.allthings.how/wp-content/uploads/2021/02/allthings.how-how-to-freeze-a-row-in-excel-image-2.png)
Now, when you scroll horizontally, the ‘First Name’ column is frozen and remains visible. You can freeze the first column of the sheet, the same way you can freeze the first row, except this time, you have to select the ‘Freeze First Column’ instead of the Freeze Top Row option in the ‘Freeze Panes’ menu. In the example, we froze the first four rows and a line separates the frozen rows and unfrozen rows. To freeze rows of your choice, first, select the row below the last row that you want to freeze, then go to the ‘View’ tab, and select the ‘Freeze Panes’ option in the Freeze Panes drop-down menu. To do that, head to the ‘View’ tab and click ‘Freeze Panes’ in the Ribbon, and select the ‘Freeze Top Row’ option.Īs you can see, the header in the following example is still visible when I scroll down to row 14.Įxcel allows you to freeze not just one row but as many rows as possible. When you scrolling down the worksheet, you might want to keep your eye on the top row which contains the header of the sheet. You can do that by the ‘Freeze Panes’ feature in Excel that keeps specific rows or columns visible when you scroll through in the worksheet.
![is it possible to freeze multiple panes in excel is it possible to freeze multiple panes in excel](https://michelpoudrier.com/images/other/993/how-freeze-more-13B3142.jpg)
If you have a large amount of data in excel and when scrolling down or scrolling horizontally, you don’t want to lose sight of a certain row or column. For instance, if the first column in your worksheet contains names, you might want to freeze that column to make sure that the names remain visible as you scroll through (horizontally) in your worksheet.