Why don't you insert a new row above the table headers and put the SUM
formulae in there?

Hoe this helps.

Pete

On Oct 11, 8:41*am, jackBoom
wrote:
I was thinking of something more permanent. It does look like what the freeze
pane feature does. I've seen this done before on other spreadsheets but I
never figured out how.



"Sheeloo" wrote:
You need to open the file then choose Window|New Window
This will open the same file in another window
Then choose Window|Arrange|Horizontal
You can display the rows which you want in the bottom window and work on the
top window.

"jackBoom" wrote:

I have a table with lots of information, 10 columns of different info and a
bunch of rows. How do I freeze a row and have it stay on the bottom of the
screen even when I scroll? I want that bottom row to sum some of the columns.

I already used freeze pane to freeze a row that is at the very top with all
the labels but I can't seem to get a row frozen at the very bottom.- Hide quoted text -

- Show quoted text -