Any way to get Freeze Panes to work with Split View?
 

Freeze Panes disappears if I split the view. Worse is if I try my general
technique of selecting row or column prior to splitting view to split as I
want it, it always does the opposite, and then when I do it again moves me to
the top column losing my place (this if i try to do so with Freeze Panes on.

I often need Freeze Top and Split Columns anyway to do so?

Any way to get Freeze Panes to work with Split View?
 

You cannot split and freeze on same sheet in same window.

One or the other.

Posiible workaround.................WindowNew Window.

Split or freeze either or both windows.


Gord Dibben MS Excel MVP

On Mon, 22 Mar 2010 07:05:01 -0700, msnyc07
wrote:

Freeze Panes disappears if I split the view. Worse is if I try my general
technique of selecting row or column prior to splitting view to split as I
want it, it always does the opposite, and then when I do it again moves me to
the top column losing my place (this if i try to do so with Freeze Panes on.

I often need Freeze Top and Split Columns anyway to do so?

Any way to get Freeze Panes to work with Split View?
 

Thanks. Too bad, it would make sense.

My work around was to do a ver/horz split and move the horz to top row.

"Gord Dibben" wrote:

You cannot split and freeze on same sheet in same window.

One or the other.

Posiible workaround.................WindowNew Window.

Split or freeze either or both windows.


Gord Dibben MS Excel MVP

On Mon, 22 Mar 2010 07:05:01 -0700, msnyc07
wrote:

Freeze Panes disappears if I split the view. Worse is if I try my general
technique of selecting row or column prior to splitting view to split as I
want it, it always does the opposite, and then when I do it again moves me to
the top column losing my place (this if i try to do so with Freeze Panes on.

I often need Freeze Top and Split Columns anyway to do so?

.