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

[msnyc07]

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?

 

[Gord Dibben]

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

One or the other.

Posiible workaround.................Window>New Window.

Split or freeze either or both windows.


Gord Dibben MS Excel MVP

 

[msnyc07]

Thanks. Too bad, it would make sense.

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