1. Computing & Technology

Discuss in my forum

Excel Freeze Panes Step by Step Tutorial

By , About.com Guide

5 of 5

Unfreeze Columns and Rows
Lock Columns and Rows in Excel with Freeze Panes

Lock Columns and Rows in Excel with Freeze Panes

© Ted French

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.

©2012 About.com. All rights reserved.

A part of The New York Times Company.