Excel Freeze Panes Step by Step Tutorial

To Unfreeze Columns and Rows

1. Click on the View tab.


2. Click on Freeze Panes from the ribbon to open the features drop down list.


3. Click on Unfreeze Panes option in the list.


4. The black border(s) showing the frozen columns and rows should disappear from the worksheet.

• Freeze Panes Overview
• Freeze the Top Row
• Freeze the First Column
• Freeze Both Columns and Rows
• Unfreeze Columns and Rows