HomePrivacy PolicyFeedbackLink to usSite Map

MS Excel: Unfreeze panes in Excel 2003/XP/2000/97


Also learn how to unfreeze panes in Excel 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003/XP/2000/97.

Question:  In Excel 2003/XP/2000/97, I have a spreadsheet that has frozen panes. How do I unfreeze the panes?

Answer:  Freezing panes could hide rows or columns, or cause the column headings to always be visible even after scrolling.

To unfreeze panes, open your Excel spreadsheet. Under the Windows menu, select Unfreeze Panes.


Now when you move around in your spreadsheet, columns and rows should display as normal.