Mac Forum / Applications / Excel / February 2006

On 19/2/06 23:42, in article C01EB2F6.1C37%caesura@mac.invalid, "Jason O"
<caesura@mac.invalid> wrote:

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*

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.