G
Guest
How do I freeze pains in both a column and row at the same time?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
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
P
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
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
G
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
below the row and to the left of the column. Go
to 'Windo' 'Freeze panes' on the tool bar.
HTH
G
Guest
is there any way to make both stay frozen at the same time?
K
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.
columns to the left and above will be frozen.