thanks Kevin and Roger, both solutions are excellent.

I have to admit I was thinking of something more along the line of Kevin's
option but that's only because (for some bizarre reason?) I didn't think of
Roger's easier option, even I could I have worked out had to do that if
I'd only thought about it a bit more!

I appreciate the help guys, eminently sensible solutions both

Thanks


"Roger Govier" wrote:

Hi

You could tackle the problem another way.
Insert a new row at the to of your screen, and put the Totals there.
Then, a simple Freeze panes will achieve what you want

Perhaps, make that row a different colour, to stand out, and put box
characters around the cells.

--
Regards
Roger Govier

"Crashhot" wrote in message
...
I knew about freezing and how to do that but thank you anyway Praveen, the
split is really useful Kevin but I cannot get them to work together!

What I'm trying to do is leave my column headings at the top and my totals
at the bottom and scroll up and down with the roads in between, if I split
the screen and then apply a freeze to keep the top still it doesn't work.

What seems to happen is whichever selection I make last (freeze or split)
that is the option I then have to use from that point onwards, any idea
how I
can make them both work together?

Thanks

"Kevin B" wrote:

Praveen's will get your top rows and left hand columns locked on screen
but
to see the total row at the bottom you'll have to split the screen. At
the
top of the vertical scroll bar is the split pane icon. When the mouse
pointer is hovering above it your mouse pointer is a double line
horizontal
bar with up/down arrows. Click and drag the bar down to the location
where
you want to display total rows.

Then click in the bottom window and bring your total rows into view.

To remove the split bar just double-click on it, or drag it back to its
original location at the top of the screen.
--
Kevin Backmann


"Praveen Potturi" wrote:

Click on the cell from which it whould freeze then go to windows on top
select freeze panes. This should work
--
Thanks,
Praveen Potturi


"Crashhot" wrote:

I want to keep the top five rows and the total row at the bottom
visible and
scroll up and down in the middle, is this possible?

Thanks