fix left column(s) and/or upper row
Great, thanks!
"Gord Dibben" wrote:
Select a cell.
Any rows above and columns left of that cell will be frozen when you Freeze
Panes.
B2 freezes row 1 and column A.
Gord
On Mon, 22 Jun 2009 00:11:01 -0700, mariekek5
wrote:
Dear Gord,
Thanks!
Actually, I can freeze either the upper row or a column on the left....but
not both... Is it possible to both freeze the upper row as well as a column
on the left?
Thanks in advance.
Marieke
"Gord Dibben" wrote:
I think Luke meant "select C2 then WindowFreeze Panes"
Gord Dibben MS Excel MVP
On Fri, 19 Jun 2009 06:07:05 -0700, Luke M
wrote:
1) Select column C, then go to Window - Freeze panes.
2) Select row 2, then go to Window - Freeze panes
Freeze panes will always freeze to the left and/or above of your current
selection.(if possible)
|