Now when you scroll down in your Excel sheet, your column number will have the position of header title. For this, you should go to the Home tab and then from the style group you should select the Format as Table. You can also format your data like a table instead of freezing top row. Now from the drop-down menu, you should select the “Unfreeze Panes”. įor this, you should click to the View tab and then from the Window group, you should select the Freeze Panes arrow sign. Now, in the opened window you should type the password and hit on OK button. Here, you should click on to the unprotect workbook. For this, you should click on the Review tab from the Excel ribbon.If there is colored background in the workbook then it is the clear indication that the protection If you want to enable the Freeze Panes option, then you should unprotect your Excel workbook.

After this, from the Workbook Views group you should select any option like normal, page break preview, or custom views. You should click on the View tab from the Excel menu. In case, your Excel workbook is in page layout view then you should quickly change it to Page Break Preview or normal view. Solution To Fix Excel Freeze Pane Not Working Issue:

Because of all this issues, Excel Freeze Panes Not Work properly. Causes of Excel Freeze Panes Not Working:Įxcel 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.

Script kasir php sederhana