Sometimes, Excel workbooks are protected by earlier versions of Excels. We can Unprotect the Worksheets by going into the Preview tab > Select Unprotect Sheet (from the Protect section).Ĭ) Worksheet Protected by Earlier Versions of Excel In order to Freeze Panes to work in those datasets, we have to first Unprotect the respective Worksheets. In businesses, users occasionally protect their Excel workbooks by inserting passwords or other means. Nevertheless, if users accidentally select preview worksheets in Page Layout Preview, he or they won’t be able to apply the Freeze Panes feature to the worksheets. The underlying reasons areĪ) Previewing Worksheet Page Layout PreviewĮxcel offers 3 Workbook Views to preview any worksheets in them. There are 3 basic reasons for Excel Freeze Panes not working. Reasons Behind Excel Freeze Panes Not Working By doing so, Freeze Panes enables users to see each entry’s row or column heading no matter how further he or she scrolls.

The Excel Freeze Panes feature locks the rows or column heading. Now you're able to compare data for similar months from several different years.Resolve Excel Freeze Panes not Working.xlsx Move your windows so they are side by side.Open a new window for your workbook and select the 2012-2013 Sales tab.Use the horizontal scroll bar in the bottom-right of the window to move the worksheet so Column N, which contains data for January 2015, is next to Column F.Hint: This should split the worksheet between rows 16 and 17 and columns F and G. Select cell G17 and click Split to split the worksheet into multiple panes.Freeze First Column and use the horizontal scroll bar to look at sales from 2015.For this challenge, we want to be able to compare data for different years side by side. Within our example file, there is A LOT of sales data. To remove the split, click the Split command again. After creating a split, you can click and drag the vertical and horizontal dividers to change the size of each section.

Can39t freeze panes excel