You cannot, for instance, freeze the third column and nothing else around it.ĭownload the spreadsheet that accompanies this tutorial to see this feature in action in Excel.
Because of all this issues, Excel Freeze Panes Not Work properly.
How to freeze multiple panes in excel windows#
You can only freeze the rows starting from the top and the columns starting from the left. The causes of this issue are when your Excel worksheet is in the page layout view, when Windows protection is turned on and also when the Excel sheet is protected by the earlier versions of Excel. Go to the View tab and click Freeze Panes and, if there are any frozen panes in the worksheet, you will see the first choice in the list titled Unfreeze Panes, click that. Unfreeze/Unlock Columns and Rows in Excel Using this method, you can freeze the first two rows, the first two columns, the first two rows and the first 2 columns at the same time, basically whatever you want. Now, I can scroll down and to the right and the first column and row will remain in place.
To freeze a column, or a set of columns, you need to select the column to the right of the column(s) you want to freeze.Note: If you don’t see the “Freeze Panes” option, it might be because you already have panes frozen. “ Freeze Top Row” will freeze only the top row no matter what row you currently have selected.“ Freeze Panes” will freeze all rows above your selected row.With the row selected, click on the “ View” tab at the top, select “ Freeze Panes” and you’ll see several different options you can choose:.To select a row, you need to select the entire row on the left side. Select the row below the row you want to freeze.