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

  • Thread starter Thread starter msnyc07
  • Start date Start date
M

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?
 
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
 
Thanks. Too bad, it would make sense.

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