Freeze panes
 

Is there a way to do both horizontal and vertical freezing of the panes in
the same worksheet?

Freeze panes
 

If you want to freeze, say, column A and Row 1 then position your
cursor in B2 before you do Window | Freeze Panes. If you want the top
two rows frozen, then position cursor in B3 first, etc.

Hope this helps.

Pete

On Jul 25, 11:36 am, swati wrote:
Is there a way to do both horizontal and vertical freezing of the panes in
the same worksheet?

Freeze panes
 

thanks it really helps!!

"Pete_UK" wrote:

If you want to freeze, say, column A and Row 1 then position your
cursor in B2 before you do Window | Freeze Panes. If you want the top
two rows frozen, then position cursor in B3 first, etc.

Hope this helps.

Pete

On Jul 25, 11:36 am, swati wrote:
Is there a way to do both horizontal and vertical freezing of the panes in
the same worksheet?

Freeze panes
 

Glad to be of help - thanks for feeding back.

Pete

On Jul 25, 1:04 pm, swati wrote:
thanks it really helps!!



"Pete_UK" wrote:
If you want to freeze, say, column A and Row 1 then position your
cursor in B2 before you do Window | Freeze Panes. If you want the top
two rows frozen, then position cursor in B3 first, etc.

Hope this helps.

Pete

On Jul 25, 11:36 am, swati wrote:
Is there a way to do both horizontal and vertical freezing of the panes in
the same worksheet?- Hide quoted text -

- Show quoted text -

Freeze panes
 

THANK YOU VERY MUCHO!!!

"Pete_UK" wrote:

If you want to freeze, say, column A and Row 1 then position your
cursor in B2 before you do Window | Freeze Panes. If you want the top
two rows frozen, then position cursor in B3 first, etc.

Hope this helps.

Pete

On Jul 25, 11:36 am, swati wrote:
Is there a way to do both horizontal and vertical freezing of the panes in
the same worksheet?