1. Home
  2. Computing & Technology
  3. Spreadsheets

Freeze Panes in Excel 2003

By Ted French, About.com

1 of 5

Using the Freeze Panes Feature

Using Freeze Panes in Excel

Using Freeze Panes in Excel

© Ted French

Using the Excel Freeze Panes Feature

It is sometimes difficult to read and understand very large spreadsheets. When you scroll too far to the right or down, you lose the headings that are located at the top and down the left side of the worksheet. Without the headings, its hard to keep track of which column or row of data you are looking at.

To avoid this problem use the freeze panes feature in Microsoft Excel. It allows you to "freeze" certain areas or panes of the spreadsheet so that they remain visible at all times when scrolling to the right or down. Keeping headings on the screen makes it easier to read your data throughout the entire spreadsheet.

1 of 5

Index: Freeze Panes in Excel 2003

  1. Using the Freeze Panes Feature
  2. Freeze Panes Using the Active Cell
  3. Using Excel Auto Fill
  4. Freeze the Panes
  5. Check the Results

Explore Spreadsheets

More from About.com

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Tools
  5. Freeze Panes in Excel - Using Excel Freeze Panes Feature - Microsoft Excel Freeze Panes

©2008 About.com, a part of The New York Times Company.

All rights reserved.