How can I display a "sliding" range?

[Guest]

I want to freeze the column headings, but also freeze a total at the bottom.
I would like to display 15 -20 rows, but be able to scroll through the list
also. For example, I would like to show rows 1 - 19 below the headings, and
above the Total. If I then hit the down arrow (which would go to row 20), I
would then like rows 2 - 20 to be displayed between the headings and the
total.

Can this be done???

 

[Guest]

Not that I know of. Probably the best/only way to do this is if you put the
Totals in the frozen column headings.

 

[Richard Buttrey]

I want to freeze the column headings, but also freeze a total at the bottom.
I would like to display 15 -20 rows, but be able to scroll through the list
also. For example, I would like to show rows 1 - 19 below the headings, and
above the Total. If I then hit the down arrow (which would go to row 20), I
would then like rows 2 - 20 to be displayed between the headings and the
total.

Can this be done???

I don't believe it can be done in the same window. Why not switch on a
second window?

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[DOR]

Why not put the total at the top, above the freeze line?

You may need to define dynamic ranges below the Headers and Total line
if you do this, or you may not if you can keep your totalled ranges
static or expand them using row insertions.

 

[Guest]

How do I define Dynamic Ranges???

 

[Rowan Drummond]

See
http://contextures.com/xlNames01.html#Dynamic

Regards
Rowan