How do I freeze a row on the bottom of my screen?

[jackBoom]

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.

 

[Sheeloo]

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]

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.

 

[Pete_UK]

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

Hoe this helps.

Pete

 

[Sheeloo]

I don't think this can be done through standard features. If you have any
such spreadsheet do send to me so that I can investigate how it has been done.

You may try Pete's suggestion.