How do I keep the headings visible while scrolling down in Excell
 

I have a large document with many lines. I would like to be able to see the
column headings as I scroll down through the document. Can anyone point me in
the right direction?

How do I keep the headings visible while scrolling down in Excell
 

Select A2 and WindowFreeze Panes

Or in 2007

Select A2 and View TabFreeze Panes

Anything above and left of the cell selected will be frozen.


Gord Dibben MS Excel MVP


On Sun, 27 Sep 2009 10:33:01 -0700, tornatus
wrote:

I have a large document with many lines. I would like to be able to see the
column headings as I scroll down through the document. Can anyone point me in
the right direction?

How do I keep the headings visible while scrolling down in Excell
 

Hi

Use Freeze panes from the Window menu.

Activate the first cell below/left to rows/columns to freeze, before you
activate Freeze panes.

Regards,
Per

"tornatus" skrev i meddelelsen
...
I have a large document with many lines. I would like to be able to see the
column headings as I scroll down through the document. Can anyone point me
in
the right direction?