Freeze /Split frames

[Thor]

I'm working on a Excel 2003 sheet. I want the three row column titles to stay
at the top as you scroll down the page AND I want the total row, a couple of
hundred rows below to always show when scrolling, This means that the title
rows and total row is always seen when scrolling.

 

[Rick Rothstein \(MVP - VB\)]

You can not freeze non-contiguous sets of rows. Can you move (or duplicate)
your totals row at the top of the worksheet (maybe set it off from the rest
of the rows with top and bottom borders) so that it and your top 3 rows can
all be frozen together?

Rick

 

[Reitanos]

The title of your post has the answer to your question:
1) Use Window/Freeze Panes command after selecting cell A3 to get the
3 rows at the top to remain when scrolling
2) Use the Split feature (accessed by the small gray box above the
vertical scroll bar or Windows/Split) to split your total row into a
separate pane that will scroll independently

 

[Rick Rothstein \(MVP - VB\)]

Am I doing something wrong? My XL2003 will only freeze or split, but not
both at the same time (the small gray box disappears when I elect to freeze
the rows).

Rick

 

[Gord Dibben]

Doing nothing wrong Rick.

You cannot use both together.

OP could conceivably use two windows.

One skinny window with totals row showing at bottom of first window.

But I would move my totals row up to the top and freeze that along with the
Title rows per your first post.


Gord

Am I doing something wrong? My XL2003 will only freeze or split, but not
both at the same time (the small gray box disappears when I elect to freeze
the rows).

Rick