Freeze panes

[Don Niall]

Hi,

Is there anyway of freezing panes along the X-axis, and Y-
axis in an excel worksheet? I have a worksheet that
traditionally I have column titles (X-axis)'frozen' ....
However as the w/s as got larger I need to do something
similar with category information along the Y-axis ...

Any ideas?

Thx,

Don-

 

[Peo Sjoblom]

If you select A2, then do window>freeze panes it will freeze
column A and row 1

 

[Peo Sjoblom]

If you select B2, then do window>freeze panes it will freeze
column A and row 1

 

[Ron de Bruin]

Hi Don

Select B2 for Example and do Window Freeze Panes
The first Row and the first column will freeze

 

[Max]

If col headers are in row1 (X-axis), row headers in col A (Y-axis)
try:

Click on B2
Click Window > Freeze Panes

Col A will stay in view as you scroll across to the right
Row1 will stay in view as you scroll down

Adjust the corner cell "B2" of the frozen panes accordingly to suit

 

[RagDyer]

Some general info on Freeze Panes:

http://tinyurl.com/2qdzt
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================




Hi,

Is there anyway of freezing panes along the X-axis, and Y-
axis in an excel worksheet? I have a worksheet that
traditionally I have column titles (X-axis)'frozen' ....
However as the w/s as got larger I need to do something
similar with category information along the Y-axis ...

Any ideas?

Thx,

Don-