1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel 2007 Freeze Panes

By Ted French, About.com

2 of 5

Freeze the Top Row

Lock Columns and Rows in Excel with Freeze Panes

Lock Columns and Rows in Excel with Freeze Panes

© Ted French


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.
  4. .
  5. A black border should appear beneath row 1 in the worksheet indicating that the area above the line has been "frozen".

  6. 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.
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.