Hi Heidi
Let say you want to freeze row 55, scroll up till row 55 is at the top of your
page,
Click on row number 55 on the extreme left to highlight the row, then goto
Window
Freeze Panes.
HTH
John
"Heidi" wrote in message
...
Say I want to freeze a row in the middle of the sheet, Line above go away and
the lines below scroll, is ther a way.