Select the cell that is one down and one to the right of the row(s) and column(s) you want frozen. Go to Windows > Freeze Pane. It'll divide the screen and everything above or to the left of the cell you selected will be frozen. That's it.
