You cannot freeze the row at the same time. 2, if you freeze the first column using Freeze First Column, only the first column of the worksheet will be frozen. You cannot freeze the column at the same time. If you freeze the top row, only the first row of the sheet will be frozen.Once the worksheet is frozen using the freeze pane feature, you cannot unfreeze the worksheet by undoing the action.There are some points that you should be aware with them. Method to freeze paneĮxcel enables three methods to freeze the pane. Inside the View tab, you will see a Windows group where this Freeze Panes option is present. This is available inside the View tab in the Excel ribbon. In that case, Freezing the row/column will help you to freeze the data for the entire worksheet scrolling horizontally and vertically.įreeze Panes is a feature of Excel that enables the users to lock the Excel rows and columns. These particular rows or columns should not be hidden when you scroll the worksheet. Sometimes, we need to scroll the entire worksheet and also want some row or column available through the entire worksheet scrolling. Freeze pane locks the specific row or column and makes them visible for the entire sheet scrolling. Here, freeze panes feature help to lock the cells so that you can see the worksheet however you want. Sometimes, you want some rows or columns always in your worksheet. In this type of scenario, Excel enables several methods, including Frozen Panes, New Window, and Split your worksheet. When you scroll the worksheet horizontally and vertically, the data of above cells hide with scrolling. Whenever you work with the large worksheet with a lot of data, it is difficult to compare data. Rows and Columns keep visible when they are frozen. They can freeze panes to freeze the single or multiple rows/columns. In Excel, users can use the Freeze Panes feature of Excel to freeze the row or column of the worksheet. When the Excel worksheet is large, freeze pane is a useful option to freeze the particular part of the worksheet and make the other part scrollable.

Excel has a freeze pane feature to freeze the part of the Excel worksheet.

Can39t freeze panes excel