How can I display a "sliding" range?
 

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???

How can I display a "sliding" range?
 

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

"msouterblight1" wrote:

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???

How can I display a "sliding" range?
 

On Mon, 7 Nov 2005 13:33:21 -0800, "msouterblight1"
wrote:

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
__________________________

How can I display a "sliding" range?
 

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.

How can I display a "sliding" range?
 

How do I define Dynamic Ranges???

"DOR" wrote:

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.

How can I display a "sliding" range?
 

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

Regards
Rowan

msouterblight1 wrote:
How do I define Dynamic Ranges???

"DOR" wrote: