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.

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.

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.

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 -

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.

"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.

From the Window menu, choose Split and then drag the splitter bar down
until only one row is visible in the bottom half of the split. Both
the upper region an lower region of the split are scrollable, but if
you don't scroll the bottom half, it remain static regardless of how
you scroll the upper half of the split.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)


On Fri, 10 Oct 2008 23:02:01 -0700, 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.