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.