1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel 2007 Freeze Panes

By , About.com Guide

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

The Best Web Trends of the Decade

A look back at the best innovations, ideas and technologies over the last 10 years, More >

Family Tech Center

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

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

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

All rights reserved.