Freezing Top and Bottom Rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

franciz - 10 Dec 2007 11:20 GMT

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)

Reply to this Message

Jim Cone - 10 Dec 2007 11:39 GMT

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)

Reply to this Message

franciz - 10 Dec 2007 12:35 GMT

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)

>
> francis,
[quoted text clipped - 15 lines]
> regards, francis
> (xlOps)

Reply to this Message

Dave D-C - 11 Dec 2007 16:36 GMT

How about using window/split?

>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
[quoted text clipped - 4 lines]
>regards, francis
>(xlOps)

Reply to this Message

Gord Dibben - 11 Dec 2007 20:16 GMT

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

>How about using window/split?
>
[quoted text clipped - 6 lines]
>>regards, francis
>>(xlOps)

Reply to this Message

Dave D-C - 12 Dec 2007 14:12 GMT

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

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

DaveD-C wrote:

>>How about using window/split?

>>>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
[quoted text clipped - 4 lines]
>>>regards, francis
>>>(xlOps)

Reply to this Message