Freezing cells

[ksholars]

I am looking for a way to freeze a row so that it stays on the top of the
worksheet as I scroll down.

 

[David Billigmeier]

Select the entire row directly below the row you want to freeze, then:

<Window>
<Freeze Panes>

 

[jchen]

Try Freez Panes. It will all rows and columns that are above or left of the
current activecell.