Freezing Column and Row Headings
When it comes to the size of your monitor versus the size of your worksheet, your monitor loses hands down every time. This means that in all except the most concise data tables, the column and row headings that identify the entries in its cells soon disappear from view as you make or edit entries in rows lower and columns further to the right than the original screen can contain. To prevent this from happening by keeping a table’s or list’s headings on the screen at all times no matter how long or wide the table or list becomes, you need to freeze these headings on the screen. To do this, position the cell cursor in the cell located immediately to the right of the column containing the row headings and immediately below the row with the column headings. Then choose View => Freeze Panes => Freeze Panes on the Ribbon (Alt+WFF).
Don’t forget that you can save the frozen panes you set up in a spreadsheet as part of a custom view for the worksheet that you can resume at any time simply by selecting its name in the Custom Views dialog box (View => Custom Views or Alt+WC).