1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Freeze Panes Step by Step Tutorial


1 of 5

Freeze Panes Overview
Excel Freeze Panes Tutorial

Excel Freeze Panes Tutorial

© Ted French

Excel Freeze Panes Overview

Related tutorial: Freeze Panes in Excel 2003.

When working with very large spreadsheets headings located at the top and down the left side of the worksheet often disappear if you scroll too far to the right or down. Without the headings, it's hard to keep track of which column or row of data you are looking at.

To avoid this problem use Excel's freeze panes feature. It "freezes" or locks specific columns or rows of the spreadsheet so that they remain visible at all times.

This tutorial covers the freeze panes options in Excel 2007 / 2010.

The steps in this tutorial are:

  1. Freeze the top row

  2. Freeze the first column

  3. Freeze both columns and rows

  4. Unfreeze columns and rows

©2014 About.com. All rights reserved.