Excel.Tips.Net ExcelTips (Menu Interface)

Displaying Row and Column Labels

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Displaying Row and Column Labels.

When you develop a worksheet you often add a row or two of labels at the top of each column, and perhaps a column of labels to the left of each row. If your worksheet becomes quite large, it is not unusual for the row and column labels to scroll off the screen so that you can no longer see them.

To keep row and column labels visible, consider "freezing" the rows and columns in which the labels are located. For instance, you could easily freeze the first four rows of a worksheet along with the first column. Then, when you scroll the worksheet the rows and columns will remain on the screen—only the unfrozen portion of the screen will scroll.

You specify what rows and columns you want to freeze by selecting the cell immediately below and to the right of the area to be frozen. For instance, if you want to freeze rows 1 through 4 and column A, you would select the cell at B5. Then, to freeze the rows and columns, you select Freeze Panes from the Window menu. Excel places a thicker black line above and to the left of the current cell to indicate the rows and columns frozen.

If you no longer need to use the frozen panes, simply choose Unfreeze Panes from the Window menu.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2591) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Displaying Row and Column Labels.

Related Tips:

Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!


Comments for this tip:

Uma    28 Oct 2014, 07:50
Thank you so much
Sun    28 Aug 2014, 22:14
If you want to freeze only the 5th row, then how can you do it?
Brian    13 Apr 2013, 15:04
Hi I just wanted to say thank you very much for describing this. It really helped out, and it was extremely clear. Thanks so much!
Sivabalakrishnan g    15 Feb 2013, 02:37
easy tamil vierku sollanumna..

1 and 2 rows rendum frees pannanumna 3 la vachi freen panes kodutha easy ya kidachitum...
simple nu solranga its also working yeah...
Sivabalakrishnan g    15 Feb 2013, 02:34
sooooo thanking you yar,,
its very usefully for my timely again thanksyouuuuuuu so much..

keep it up yar!!!!!!
Tediousboy    12 Dec 2012, 03:47
Thanks very much.
Solve a big problem for me.
Jiyaad    06 Aug 2012, 09:47
So good, exactly what I was looking for, thanks!

Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 4+5 (To prevent automated submissions and spam.)
          Commenting Terms

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2013)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2013)

Our Products

Premium Newsletters

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2015 Sharon Parq Associates, Inc.