Things That Can Go Wrong with Freeze Panes… and How to Fix Them

In my book, I stick to solutions that work. But when I teach an Excel course, I take time to point out things that can go wrong. For example, has your screen ever had crosshairs in the middle of the worksheet? If you’re not sure what I’m talking about, please click this link to open an Excel 2007 file (zipped, no macros) named “Freeze-Panes-Problems-1.xlsx” to view the problem. Or, have you ever opened a spreadsheet and tried to move down the spreadsheet using either the scroll bar or keyboard down arrow but nothing seemed to happen? Please click this link to open an Excel 2007 file (zipped, no macros) named “Freeze-Panes-Problems-2.xlsx” to view this situation.

Both of these problems are a result of someone incorrectly applying the Freeze Panes feature. In the first case, the crosshairs in the middle are a result of someone applying the Freeze Panes feature while Cell A1 is the active cell. In the second case, this can happen if someone applies the Freeze Panes feature while the data is filtered.

To fix the problem in the first case, Unfreeze the Panes, click some cell other than Cell A1, and reapply the Freeze Panes feature. To fix the problem in the second case, Unfreeze the Panes, make sure the data is not filtered, and reapply the Freeze Panes feature.

For more information on the Freeze Panes feature, please see Chapter 2 of "Simply learning Excel 2007."

This entry was posted in Excel Freeze Panes. Bookmark the permalink.

13 Responses to Things That Can Go Wrong with Freeze Panes… and How to Fix Them

  1. Frankie Peele says:

    Fantastic. Thank you so much for providing a solution to my Filter and Freeze Panes issue.

  2. Lisa Boban says:

    Damn. I messed with this for hours before I found your answer. Many Many Many thanks!

  3. Gordon B says:

    my problem is that if I select top two rows and then freeze panes it freezes a different amount of rows …. sometimes 14, 19, 28 etc. It never did this before …. how do I fix this?? I’m on a MAC using Office 8

  4. CRitter says:

    Hi Bob, thanks for sharing.
    Moreover, be sure to remove any splitting before freezing panes again.

  5. Scott Bohm says:

    I am trying to freeze row and column so I can scroll through data. The title or top row is frozen only. I can’t get A column to freeze. I am using Excel 2010. Data is not filtered or split….Do you have any suggestions?

    Thanks

  6. Scott Bohm says:

    Thanks Bob…I have tried B2 and it just freezes the titles. I cant seem to get it to freeze the titles and first column together so I can scroll the data….any other suggestions….

    thanks
    Scott

    • Bob Ryan says:

      Scott – I don’t understand why that doesn’t work. To be sure I understand, after you were sure the panes were not frozen, you clicked Cell B2, froze the panes (View > Freeze Panes dropdown > Freeze Panes (NOT freeze top row)), and when you scrolled to the right, the first column did not stay visible?

  7. Mike Peckmann says:

    I am having a simular problem that Scott is having. I want to freeze row 1 and 2 and column A. It doesn’t matter what cell I have selected it still gives me the “crosshair” in the middle of the sheet. It freezes column A to row 16 and row 1 and 2 to column J. My data goes past these quadrants

    • Bob Ryan says:

      Mike – Based on your comments, I recommend you unfreeze the panes first (View > Freeze Panes dropdown > Unfreeze Panes). After you do that, you should be able to select Cell B3, and freeze the panes as I described in my response to Scott. Will you let us know whether it worked?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>