Freeze Panes

You can lock certain rows or columns in place as you scroll through a worksheet. Position your cursor below any rows and/or to the right of any columns that you wish to freeze in place, then choose Window and Freeze Panes. Unlock the rows/columns by choosing Window, and then Unfreeze Panes.