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