To Freeze a Column and Row Title on the Screen when Using Excel:
- Choose the cell to the right of the column and below the row you want to be visible on the screen at all times in order to freeze both a column and a row.
- Choose the View tab on the Ribbon.
- Choose the Freeze Panes option on the Ribbon under the View tab.
- Choose Freeze Panes to freeze both the column and the row. If you would like to freeze just the row of column headings, choose Freeze Top Row, or if you would like to freeze the column of row titles, choose Freeze First Column. Freezing Column and Row Titles does not affect the printing of the document.