lock-out rows from scrolling

[John A Grandy]

how to lock an upper set of consecutive rows to remain visible while the
rows below them scroll out of view?

example:
rows 1-5 always visible
rows 6-bottom scroll up "behind" rows 1-5

 

[John Wilson]

John,

Select cell A6
Window/Split
Window/Freeze Panes

Depending on what cell you're on when you do this, you can
lock the lefthand columns too.

John

 

[Thomas]

Select a cell in row6 ,Window>Freeze Pane

 

[J.E. McGimpsey]

manually:

Select cell A6 (or another cell in row 6 if you want to lock in
column(s) too). Choose Window/Freeze Panes

Programmatically (since this is the programming group):

Range("A6").Select
ActiveWindow.FreezePanes = True

 

[Gord Dibben]

John

No need for Window/Split. Freeze Panes will suffice.

Gord Dibben Excel MVP - XL97 SR2 & XL2002

 

[John Wilson]

Gord,

I've been using that Split/Freeze sequence ever since
I started using Excel and have no idea why I started
doing it that way.
For some reason, I thought that's how it had to be done.
Oh well, learned something new yet again.

Thanks,
John