Freezing Top and Bottom Rows

[franciz]

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)

 

[Jim Cone]

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)

 

[franciz]

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)

 

[Dave D-C]

How about using window/split?

 

[Gord Dibben]

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

You could create a new window....Window>New

Window>Arrange>Horizontal

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

 

[Dave D-C]

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