Multiple Spits on one worksheet

[realranger]

Hi I am using Excel 2003 and want to have a split/freeze at the top of my
screen where my column headings are always visble (this part I can manage)
but also want to have a split at the bottom so as I can see the totals of
each column always in view.

Any help would be very much appreciated.

 

[Dave Peterson]

Excel doesn't allow you to have more than one split or one freeze pane.

But you could open a new window
window|new window
followed by
window|arrange|horizontal (check windows of active workbook if you like)

And resize them the way you like.

When you're done, you can close a window by selecting it and hitting ctrl-w.

==========
Usually if I want to see stuff at the bottom of the data, it's totals/summaries.

I've learned to put them at the top of the worksheet -- higher than the
headings.

In fact, if I apply data|filter|autofilter, I'll make sure my totals are derived
by using =subtotal(), not =sum().

 

[Gord Dibben]

One split or one Freeze Panes per worksheet is all you get.

You could create two horizintal windows.

Top window has freeze panes set.

Bottom window can be sized to just show the totals row.

Kinda klunky but depends on how badly you need it.

You could also place your totals row in row two below your headings row.

Freeze Panes below those two rows.


Gord Dibben MS Excel MVP