To hold rows and column titles in place so that they do not scroll when you scroll a worksheet :
AUnfreeze panes command on the window menu
BFreeze panes command on the Window menu
CHold titles command on the edit menu
DSplit command on the Window menu