answergaq.blogg.se

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 is active. If you want to enable the Freeze Panes option, then you should unprotect your Excel workbook. This, from the Workbook Views group you should select any option like normal,

For this, you should click on the View tab from the Excel menu. Page layout view then you should quickly change it to Page Break Preview or normal Solution To Fix Excel Freeze Pane Not Working On and also when the Excel sheet is protected by the earlier versions of Excel.īecause of all this issues, Excel Freeze Panes Not Work properly. Hence, in this blog you will read the solution to fix Excel freeze panes not working issue.Įxcel worksheet is in the page layout view, when Windows protection is turned To enjoy the features of MS Excel, you should install MS Office in your device through But sometimes this feature stops working. As a result, heading will always displays on your screen when you scroll your worksheet.

It is because when you scroll down and see the rest of the sheet, its first row and column gets stick on the screen. Excel Freeze Panes feature is the very helpful feature and is basically used to lock row or column headings.