Question: How to freeze a title row or column in Excel so that the row or column stays in place when scrolling?

Answer: Use the freeze panes or freeze row or freeze column feature.

If you want to freeze both rows and columns or more than one row or one column, first select the area you want to scroll. You only need to select the first few rows and columns of the area you want to freeeze.

Go to the View menu and Freeze Panes feature (alt-w f). Select the option you want.

See Microsoft Excel freeze panes
http://office.microsoft.com/en-us/excel/results.aspx?qu=freeze+panes&sc=9&av=ZXL120&ofcresset=1