Id like to freeze the first row for headers and freeze the very b.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 17 Dec 2004 20:55 GMT

Id like to be able to freeze the very first row for headers and freeze the
very bottom row for totals only and be able to scroll thru the rows in
between can i do this?

Reply to this Message

Frank Kabel - 17 Dec 2004 20:59 GMT

Hi
no you can't do this in Excel

Signature

Regards
Frank Kabel
Frankfurt, Germany

> Id like to be able to freeze the very first row for headers and
> freeze the very bottom row for totals only and be able to scroll thru
> the rows in between can i do this?

Reply to this Message

Debra Dalgleish - 17 Dec 2004 21:12 GMT

You can freeze the top and left of a window, but not the bottom.

To freeze the top row:
Select Row 2
Choose Window>Freeze Panes

To simulate freezing the bottom row, you could open a new window
(Window>New Window).
Choose Window>Arrange, and select Horizontal
Resize the windows so the lower one is quite short.
Scroll to the total row in the lower window

> Id like to be able to freeze the very first row for headers and freeze the
> very bottom row for totals only and be able to scroll thru the rows in
> between can i do this?

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message