Freezing pains

[Guest]

How do I freeze pains in both a column and row at the same time?

 

[John Wilson]

Jason,

I have freezing pains everytime I have to shovel snow.

To freeze both the column and row select the cell directly
to the right and directly below where you want the pane frozen.
Then from the menu bar ... Window/Freeze Panes

John

 

[PTT, Inc.]

Can't do it that I know of. You can set the "freeze" for both, but as you
scroll only one will stay put. I would assume you know this, but if Row 1
and Column A are your items to freeze, place your cursor in B2, click
"Window", "Freeze Panes".

I do like the Freudian slip though (pains)! HA!

Bill Foley
www.pttinc.com

 

[GerryK]

Highlite the cell where you want the freeze to take place
below the row and to the left of the column. Go
to 'Windo' 'Freeze panes' on the tool bar.
HTH

 

[Guest]

is there any way to make both stay frozen at the same time?

 

[Ken Wright]

Click on any cell and hit Window / Freeze Panes, and then both the rows and the
columns to the left and above will be frozen.