I am trying to freeze 2 panes... one limits me to go further up (which I can
do)
and the other limits me to go further up "at another lower row".

So there will be 3 windows in the excel sheet. The top window is frozen, the
middle window I can only scroll up and down until I hit the frozen pane of
upper limit and lower limit, and the bottom window can go as low as row 65536
and it can scroll up to the 2nd pane row (where ever it is) .

Is there anyway to do this? If so, which version of MS Excel do I need?

Cannot be done.

One freeze per window.

Experiment with WindowNew Window and WindowArrangeHorizontal

Each of these two windows can have frozen panes at different spots.

Maybe even 3 windows?


Gord Dibben MS Excel MVP


On Mon, 22 Dec 2008 13:42:03 -0800, Erol
wrote:

I am trying to freeze 2 panes... one limits me to go further up (which I can
do)
and the other limits me to go further up "at another lower row".

So there will be 3 windows in the excel sheet. The top window is frozen, the
middle window I can only scroll up and down until I hit the frozen pane of
upper limit and lower limit, and the bottom window can go as low as row 65536
and it can scroll up to the 2nd pane row (where ever it is) .

Is there anyway to do this? If so, which version of MS Excel do I need?

Thanks for the suggestion. I thought it couldn't have be done either.

But I really wanted, so my coworkers could fill the data without getting
confused with more than 1 window.

I hope next MS Excel version will have this option.


"Gord Dibben" wrote:

Cannot be done.

One freeze per window.

Experiment with WindowNew Window and WindowArrangeHorizontal

Each of these two windows can have frozen panes at different spots.

Maybe even 3 windows?


Gord Dibben MS Excel MVP


On Mon, 22 Dec 2008 13:42:03 -0800, Erol
wrote:

I am trying to freeze 2 panes... one limits me to go further up (which I can
do)
and the other limits me to go further up "at another lower row".

So there will be 3 windows in the excel sheet. The top window is frozen, the
middle window I can only scroll up and down until I hit the frozen pane of
upper limit and lower limit, and the bottom window can go as low as row 65536
and it can scroll up to the 2nd pane row (where ever it is) .

Is there anyway to do this? If so, which version of MS Excel do I need?