Freeze Panes in Excel 2003

Freeze the Panes

Lock Columns and Rows in Excel with Freeze Panes

© Ted French

Freeze the Panes in Excel

Now for the easy part:

1. Click on cell D4
2. Choose Window > Freeze Panes from the menu

A vertical black line will appear between columns C and D and a horizontal line between rows 3 and 4.

Rows 1 to 3 and columns A to C are the frozen areas of the screen.

• Using the Freeze Panes Feature
• Freeze Panes Using the Active Cell
• Using Excel Auto Fill
• Freeze the Panes
• Check the Results