View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default How do I freeze a row on the bottom of my screen?

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.