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

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.