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