This entry was posted in MS Excel and tagged Excel Freeze Rows and Columns, Freeze Panes broken, Freeze Panes Not Work in Excel, Freeze panes not working properly, /setup, Bookmark the. Read here also> How You Can Easily Setup iCloud on Different Devices? The experts are available for the customer 24/7. But if the customer needs any kind of technical assistance then they can contact to the customer care executive of MS Office through /setup. The above method will help you to fix Excel Freeze Panes Not Working Issue. If above method does not work then you should use the MS Excel Repair Tool to fix the corruption issue in your Excel workbook. Scroll down in your Excel sheet, your column number will have the position of Then from the style group you should select the Format as Table. For this, you should go to the Home tab and Now from the drop-down menu, you should select the “Unfreeze Panes”. Tab and then from the Window group, you should select the Freeze Panes arrow 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.

How to freeze 2nd row in excel