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

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?
 
G

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
 
M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top