Hi all

Is it possible to freeze the top rows and the bottom row so that the headers
and the totals are always visible. In this case, I could simply scoll in
between.

I am using Excel 2003 SP3. Thank you in advance.

regards, francis
(xlOps)

francis,
Excel does not provide for the freezing of bottom rows.
You might consider putting the totals in the frozen section at the top.
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"franciz"
wrote in message
Hi all

Is it possible to freeze the top rows and the bottom row so that the headers
and the totals are always visible. In this case, I could simply scoll in
between.
I am using Excel 2003 SP3. Thank you in advance.
regards, francis
(xlOps)

Hi Jim,

Thank for looking into this. I was hoping that there is a way to tweak this
or hidden feature in Excel for doing this.

francis
(xlOps)

"Jim Cone" wrote:


francis,
Excel does not provide for the freezing of bottom rows.
You might consider putting the totals in the frozen section at the top.
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"franciz"
wrote in message
Hi all

Is it possible to freeze the top rows and the bottom row so that the headers
and the totals are always visible. In this case, I could simply scoll in
between.
I am using Excel 2003 SP3. Thank you in advance.
regards, francis
(xlOps)

How about using window/split?

franciz wrote:
Is it possible to freeze the top rows and the bottom row so that the headers
and the totals are always visible. In this case, I could simply scoll in
between.

I am using Excel 2003 SP3. Thank you in advance.

regards, francis
(xlOps)

Unfortunately you can't use Freeze Panes and Split at the same time.

You could create a new window....WindowNew

WindowArrangeHorizontal

Size the bottom one so it just shows your Totals.

Freeze Panes on the top one so row1 is visible as you scroll down.


Gord Dibben MS Excel MVP

On Tue, 11 Dec 2007 09:36:00 -0700, Dave D-C wrote:

How about using window/split?

franciz wrote:
Is it possible to freeze the top rows and the bottom row so that the headers
and the totals are always visible. In this case, I could simply scoll in
between.

I am using Excel 2003 SP3. Thank you in advance.

regards, francis
(xlOps)

Thank you for the correction.
I can't believe I didn't try it. It sounded so logical.
I really like the variety of approaches in this group,
and appreciate the constructive comments.
Most of the approaches work. :) Dave D-C

Gord Dibben <gorddibbATshawDOTca wrote:
Unfortunately you can't use Freeze Panes and Split at the same time.

DaveD-C wrote:
How about using window/split?

franciz wrote:
Is it possible to freeze the top rows and the bottom row so that the headers
and the totals are always visible. In this case, I could simply scoll in
between.

I am using Excel 2003 SP3. Thank you in advance.

regards, francis
(xlOps)