lock-out rows from scrolling
 

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

lock-out rows from scrolling
 

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

John A Grandy wrote:

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

lock-out rows from scrolling
 

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

In article ,
"John A Grandy" wrote:

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

lock-out rows from scrolling
 

John

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

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On Sat, 12 Jul 2003 18:08:58 -0400, John Wilson wrote:

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

John A Grandy wrote:

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

lock-out rows from scrolling
 

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

Gord Dibben wrote:

John

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

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On Sat, 12 Jul 2003 18:08:58 -0400, John Wilson wrote:

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

John A Grandy wrote:

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