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?