1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel 2007 Freeze Panes

By Ted French, About.com

3 of 5

Freeze the First Column

Lock Columns and Rows in Excel with Freeze Panes

Lock Columns and Rows in Excel with Freeze Panes

© Ted French


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.

  4. A black border should appear to the right of column A in the worksheet indicating that the area to the right of the line has been "frozen".

  5. 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.
Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Tools
  5. Excel 2007 Freeze Panes - Lock Columns and Rows in Excel

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

All rights reserved.