Column Headings Scroll out of view

[Guest]

Hi,

How can I get my column headings to stay put when I scroll up and and list?

Thanks in Advance

G

 

[Anne Troy]

Select A2 (usually), and hit Window-->Freeze Panes. Everything above the
selected cell will freeze in place; everything to the left will freeze in
place.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Georgea]

The first time that I tried this in Sheet 1 it works - i.e., freezes top and
left side of page. Then in Sheet 2 I tried to repeat and it only freezes the
top and not also the left side of the page. What has gone wrong?

Georgea

 

[Tyro]

If you want to freeze row 1 and column A you would select cell B2 before
freezing. If you selected A2, only row 1 would be frozen.

tyro

 

[Gord Dibben]

Select B2 if you want to freeze row 1 and column A

Rule is: everything above and to the left of the selected cell will be frozen
when you Window>Freeze Panes


Gord Dibben MS Excel MVP