1. Computing

Freeze Panes in Excel 2003

By

1 of 5

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

Lock Columns and Rows in Excel with Freeze Panes

© Ted French

Lock Columns and Rows in Excel 2003 with Freeze Panes

Related tutorial: Excel 2007 / 2010 Freeze Panes.

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.

©2014 About.com. All rights reserved.