Microsoft Excel 2007 – Freeze Rows and Columns

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 Excel lets you "freeze" or lock specific columns or rows of the spreadsheet so that they remain visible at all times.

Freeze the Top Row

1. Click on the View tab.

2. Click on Freeze Panes from the ribbon to open the features drop
    down list.

3. Click on Freeze Top Row option in the list.

Scroll down through the worksheet. If you scroll far enough, the rows below row 1 will begin disappearing while row 1 will stay on the screen.

Freeze the First Column

1. Click on the View tab.

2. Click on Freeze Panes from the ribbon to open the features
    drop down list.

3. Click on Freeze First Column option in the list.

Scroll to the right in the worksheet. If you scroll far enough, the columns to the right of column A will begin disappearing while column A will stay on the screen.

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.