Freezing Table’s Titles Row in Microsoft Excel

Imagine you have a very long table in a Microsoft Excel sheet, such as the one below:

Microsoft Excel 2003: Freezing Panes 1

And imagine that you want to edit entry No. 057:

Microsoft Excel 2003: Freezing Panes 2

If there are many columns, you will be confused as to what to change and what the data are.

You can solve this problem using the Freeze Panes command found under the Window menu:

Microsoft Excel 2003: Freezing Panes 3

To freeze the title row, click the row below it …

Microsoft Excel 2003: Freezing Panes 4

… and then click Freeze Panes in the Window menu. The rows above where you selected will be frozen:

Microsoft Excel 2003: Freezing Panes 5

Note the thin black line under the row containing the titles. It means the rows above this line will not move when you scroll down and up in the sheet.

Similarly, if the titles are in a column, click the column to its right and freeze it.

To unfreeze, click Unfreeze Panes under the Window menu:

Microsoft Excel 2003: Freezing Panes 6

I attached the file for you to experiment with it.


Attachment: Example 01.xls

Advertisements

Tags: ,

One Response to “Freezing Table’s Titles Row in Microsoft Excel”

  1. Using the Ctrl Button to Select Non-Adjacent Cells « Odd Number 7 Says:

    […] us take the file named “Example 01.xls” from a previous post as an […]

Comments are closed.


%d bloggers like this: