Column Headings Scroll out of view
 

Hi,

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

Thanks in Advance

G

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


"Grd" wrote in message
...
Hi,

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

Thanks in Advance

G

Column Headings Scroll out of view
 

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

"Anne Troy" wrote:

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


"Grd" wrote in message
...
Hi,

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

Thanks in Advance

G

Column Headings Scroll out of view
 

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

"Georgea" wrote in message
...
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

"Anne Troy" wrote:

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


"Grd" wrote in message
...
Hi,

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

Thanks in Advance

G

Column Headings Scroll out of view
 

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 WindowFreeze Panes


Gord Dibben MS Excel MVP

On Sun, 6 Jan 2008 14:53:01 -0800, Georgea
wrote:

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

"Anne Troy" wrote:

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


"Grd" wrote in message
...
Hi,

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

Thanks in Advance

G