Keeping cells in place

[Rj]

How do I keep the (A) Cloumn in from moving if I have the page view go Left
and right?

And the (1) Row from moving if I move the page up & down?

 

[Lady Layla]

Place your cursor in cell B2 and go to Window | Freeze Pane


: How do I keep the (A) Cloumn in from moving if I have the page view go Left
: and right?
:
: And the (1) Row from moving if I move the page up & down?

 

[Rj]

Thanks

 

[Gord Dibben]

Select B2 and Window>Freeze Panes.


Gord Dibben Excel MVP