fix left column(s) and/or upper row

[mariekek5]

Hello,

Two questions:

1) is it possible to fix the left column or maybe the two most left columns
on the left side of the sheet...so that when one goes to the right the left
column(s) will stay visible.

2) same question for the upper row. I know I can freeze panes...but if the
sheet is bigger than what I can see, it fixes it in the current view...while
I still want to be able to see all columns, while going to the left or the
right.

 

[Luke M]

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)

 

[Gord Dibben]

I think Luke meant "select C2 then Window>Freeze Panes"


Gord Dibben MS Excel MVP

 

[mariekek5]

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

 

[Don Guillett]

Unfreeze>place cursor where desired>freeze
rows below cursor and columns to left will be frozen

 

[Gord Dibben]

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

 

[mariekek5]

Great, thanks!

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