Prev: Inserting Rows...but losing "FORMAT"
Next: Menus in xlmenubar
From: msnyc07 on 22 Mar 2010 10:05
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?
From: Gord Dibben on 22 Mar 2010 10:50
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

On Mon, 22 Mar 2010 07:05:01 -0700, msnyc07
<msnyc07(a)discussions.microsoft.com> 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?

From: msnyc07 on 22 Mar 2010 13:32
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.................Window>New Window.
>
> Split or freeze either or both windows.
>
>
> Gord Dibben MS Excel MVP
>
> On Mon, 22 Mar 2010 07:05:01 -0700, msnyc07
> <msnyc07(a)discussions.microsoft.com> 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?
>
> .
>
 | 
Pages: 1
Prev: Inserting Rows...but losing "FORMAT"
Next: Menus in xlmenubar