Freeze Panes - Why not twice?

[Jason O]

[Sorry about the mis-post earlier]

Hi,

I'm just wondering if & HOW it is possible to freeze panes in TWO locations.
I have a very simple (but long) table in the following (simplified) form:

Title Title Amount
---------------------------------
Data Data number
Data Data number
Data Data number
Data Data number
Data Data number
Data Data number
. . .
. . .
. . .
. . .
----------------------------------
TOTAL number (SUM)
==================================

The pane is presently frozen below the 'title / amount' row for clarity's
sake. Howver, ideally I would like the 'TOTAL' row also to be frozen so
this is also visible on screen at all times - meaning the only rows that
scroll are the 'Data....number' rows (between the title & total rows that
would remain visible & fixed).

It seems that 2 freezes are not possible, OR a freeze and a split?

Can this be done?

Any help greatly appreciated (and sorry if the example isn't clear...I'd be
glad to elaborate).

TIA.


Cheers,

Jason
___
*Replace .invalid with .com for replies*

 

[Jason O]

GOD! I don't know why that happened again?!....Try Again


Hi,

I'm just wondering if & HOW it is possible to freeze panes in TWO locations.
I have a very simple (but long) table in the following (simplified) form:

Title Title Amount
---------------------------------
Data Data number
Data Data number
Data Data number
Data Data number
Data Data number
Data Data number
. . .
. . .
. . .
. . .
----------------------------------
TOTAL number (SUM)
==================================

The pane is presently frozen below the 'title / amount' row for clarity's
sake. Howver, ideally I would like the 'TOTAL' row also to be frozen so
this is also visible on screen at all times - meaning the only rows that
scroll are the 'Data....number' rows (between the title & total rows that
would remain visible & fixed).

It seems that 2 freezes are not possible, OR a freeze and a split?

Can this be done?

Any help greatly appreciated (and sorry if the example isn't clear...I'd be
glad to elaborate).

TIA.


Cheers,

Jason
___
*Replace .invalid with .com for replies*

 

[Jason O]

GOD! I don't know why that happened again?!....Try Again

I'm beginning to look like a twat now!...I know it was sent OK as have just
reviewed the post in my sent items folder & it's fine? So I don't know
what's happened. I'm gonna try one more time before I go over to
microsoft.public.mac.entourage to post a question as to why this posted
question isn't posting properly! Jeeez...!....Here goes >
GOD! I don't know why that happened again?!....Try Again


Hi,

I'm just wondering if & HOW it is possible to freeze panes in TWO locations.
I have a very simple (but long) table in the following (simplified) form:

Title Title Amount
---------------------------------
Data Data number
Data Data number
Data Data number
Data Data number
----------------------------------
TOTAL number (SUM)
==================================

The pane is presently frozen below the 'title / amount' row for clarity's
sake. Howver, ideally I would like the 'TOTAL' row also to be frozen so
this is also visible on screen at all times - meaning the only rows that
scroll are the 'Data....number' rows (between the title & total rows that
would remain visible & fixed).

It seems that 2 freezes are not possible, OR a freeze and a split?

Can this be done?

Any help greatly appreciated (and sorry if the example isn't clear...I'd be
glad to elaborate).

TIA.


Cheers,

Jason
___
*Replace .invalid with .com for replies*

 

[Harvey Waxman]

The pane is presently frozen below the 'title / amount' row for clarity's
sake. Howver, ideally I would like the 'TOTAL' row also to be frozen so
this is also visible on screen at all times - meaning the only rows that
scroll are the 'Data....number' rows (between the title & total rows that
would remain visible & fixed).

Probably not very elegant but maybe you could put the totals at the top of the
columns instead of the bottom. I've done this lots of times and it seems to
solve the problem for me.