1. Home
  2. Computing & Technology
  3. Spreadsheets

Freeze Panes in Excel 2003

By , About.com Guide

5 of 5

Check the Results

Lock Columns and Rows in Excel with Freeze Panes

Lock Columns and Rows in Excel with Freeze Panes

© Ted French

Freeze Panes in Excel - Check the Results

Use the scroll arrows to see the effect of freezing panes on a spreadsheet.

Scroll Down

  • Use the vertical scroll arrow in Excel to scroll down. Rows 1 to 3 should stay on screen, including the months of the year while the numbers 1 to 9 disappear off the spreadsheet page.

Return to cell D4

  1. Click on the Name Box above column A
  2. Type D4 in the Name Box and press the ENTER key on the keyboard. The active cell becomes D4 once again.

Scroll Across

  • Use the horizontal scroll arrow to scroll to the right. Column A should stay on the screen, including the numbers, while the months of the year disappear off the spreadsheet page.
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. Freeze Panes in Excel - Check the Results of the Freeze Panes Feature

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

All rights reserved.